Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “unific” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
unific113746(None) 
anisic8313792anisic
deific1237312deific
dunitic1048142dunitic
omnific1443812omnific
unchic1338642unchic
unfit84518562un_fit
unfix15429032un_fix
uniface1236952uniface
unified112413572unified
unifier102211862unifier
unifies102714712unifies
unify113611112unif_y
acidic113612133acidic
acinic104713543acinic
adipic1137263adipic
amidic114012873amidic
aminic104413513aminic
anemic102713693anemic
anilin6417793anilin
animi74016663animi_
animis84615943animis
anionic9312873anionic
anodic92813133anodic
anomic102516303anomic
anoxic152610673anoxic
antic75728863an_tic
anuric8812103anuric
augitic1038283augitic
auxinic1644713auxinic
benefic1446043benefic
bifid11910703_bifid
bulimic1345143bulimic
civic123412543_civic
clinic104312793clinic
clitic103315053clitic
crisic103611843crisic
critic103616813critic
edifice1344933edifice
enatic8317563enatic
enolic8413353enolic
exilic1597783exilic
fanfic1436313fanfic
fundic12389083fun_dic
fungic12387813fun_gic
gnomic11248593gnomic
gonidic1166103gonidic
imidic11358203imidic
infix15337773in_fix
iridic9328743iridic
iritic83213823iritic
juridic1744663juridic
knife1210010133knif_e
knifed14528123knifed
knifer13598563knifer
knifes136210213knifes
knifing1536483knifing
lunatic938753lunatic
mafic125615463_mafic
magnific1654213magnific
mimic111414323_mimic
motific1446323motific
naric76824173_naric
nidi56524393_nidi_
nifty115211633_nifty
nihil8410283_nihil
niobic1037243_niobic
nisi45823243_nisi_
nitid61817833_nitid
nitric82512063_nitric
nixie125114943_nixie
oneiric945613oneiric
ontic74418573on_tic
orifice1246343orifice
ossific1243103ossific
otitic83112683otitic
oxidic1635943oxidic
pacific1646913pacific
pontific1545563pontific
punditic1364983punditic
quinic17319473quinic
quintic18308883quintic
rubidic1264543rubidic
runic73615773run__ic
sniff113915863snif_f
sniffs12378843sniffs
sniffy15337193sniffy
trifid1039063trifid
tunic74018223tun__ic
umiac938963umi_ac
unacidic1343433unacidic
unai44824783un_ai_
unais53420773un_ais
unakin10310963unakin
unbid83214643un_bid
unci65019463un_ci_
uncia75015163un_cia
uncini8310153uncini_
uncivil1244793uncivil
unclip1046993unclip
uncoil8811853uncoil
uncomic1346923uncomic
undid72415363un_did
unfair936233unfair
unfed94614223un_fed
unfits93910293unfits
unfixt16398423unfixt
unguis738453unguis
unhair937333unhair
unhip10178823un_hip
unifaces1346393unifaces
unifiers11237173unifiers
unifilar1143263unifilar
uniform1247053uniform
unifying1537553unifying
union54519793uni_on
unions64216753unions
unipod946853unipod
unique1558163unique
unironic1046053unironic
unisex1358353unisex
unisize1647343unisize
unison649033unison
unit45140073un__it
unite54828383uni_te
united74421543united
uniter64619143uniter
unites65024853unites
unities72520153unities
uniting8315823uniting
unitive10310563unitive
unitize16310033unitize
units54923433uni_ts
unity84918493uni_ty
unknit1068593unknit
unlaid7311753unlaid
unlit55025463un_lit
unmix14388973un_mix
unnail6410583unnail
unpaid939473unpaid
unpick1446903un_pick
unpin72613243un_pin
unrig61711413un_rig
unrip72012863un_rip
unsaid7411833unsaid
unship1148033unship
unslick1356023unslick
unstick1338123unstick
untie54425493un_tie
until53517743un_til
untrim8310683untrim
unveil957343unveil
unvoice12126153unvoice
unwit84417523un_wit
unzip16207623un_zip
uranic82315183uranic
uranitic10148683uranitic
uratic83016353uratic
ureic74514463u_reic
uremic103410513uremic
uretic82914353uretic
uric63624933u__ric
uveitic1244683uveitic
vinic10314973_vinic
vivific1843363vivific
zincic1935903zincic

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1261418182.5
2DLD Change Limit1127161665.75019602.8
3Display Results1661660.0463608.7
 (SQL Overall)1786911665.92230174.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.