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 “unifier” 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.

297 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
unifier10221186(None) 
unified112413571unified
unifiers11237171unifiers
unifies102714711unifies
deifier113013122deifier
edifier11309262edifier
knifer13598562knif_er
niffer12378442_niffer
niftier10328712_niftier
purifier1338562purifier
reifier103414522reifier
sniffer13318902sniffer
sniffier14356632sniffier
snifter10349622snifter
uglifier1244502uglifier
unific1137462unifi_c
unifilar1143262unifilar
uniquer1675782uniquer
uniter64619142uni_ter
unities72520142unities
unitizer1746202unitizer
untidier946782untidier
airier64619363_airier
angrier839023angrier
antsier7410773antsier
auntlier834903auntlier
basifier1337313basifier
beefier12329093beefier
brinier93613463brinier
buffier1568403buffier
bunchier1536153bunchier
cliffier1633913cliffier
codifier1447153codifier
comfier1439163comfier
conifer123212643conif_er
crucifier1644313crucifier
daffier1457833daffier
defier105118653_defier
deified123112413deified
deifiers12348993deifiers
deifies113317453deifies
dicier94416233_dicier
differ133910843_differ
dingier93513673dingier
dinkier123411503dinkier
drifter11348703drifter
driftier1275123driftier
dungier9368583dun_gier
edified12339713edified
edifiers12336673edifiers
edifies113012283edifies
envier939673en_vier
fifer115519973_fif_er
finnier10319953finnier
funkier14349983fun_kier
funnier103210163fun_nier
fusilier1135413fusilier
gasifier1236273gasifier
ginnier8298983ginnier
goofier11339313goofier
grifter113810493grifter
grimier103210433grimier
gripier103210323gripier
gulfier1137793gulfier
gunfire1134743gun_fire
gunkier12369553gun_kier
hairier103111053hairier
heifer1238203heif_er
hinkier143610793hinkier
huffier1637493huffier
humified1745653humified
hungrier1233893hungrier
hunkier144512143hun_kier
icier74313753__icier
iffier1236763_iffier
ignified1386213ignified
ignifies1277563ignifies
infer84215033in_f_er
inkier104013783in_kier
inlier63615363in_lier
jivier16438613_jivier
juicier1635463juicier
junglier1644303junglier
juniper1634023juni_per
junkier18339493jun_kier
justifier1944363justifier
kinkier10319433kinkier
knife1210010133knif_e_
knifed14528123knif_ed
knifers14537083knif_ers
knifes136210213knif_es
knifing1536483knifing
knitter11348133knitter
leafier10329833leafier
lifer85822153_lif_er
lifter93814813_lifter
limier83518723_limier
lingier84113383lingier
linier64423793_linier
lintier73613803lintier
livier97514593_livier
lucifer1234603lucif_er
lunier64617603lun__ier
magnifier1545273magnifier
miffier1537023miffier
mincier113512463mincier
mingier103815293mingier
minified1439653minified
minifies13312893minifies
mintier93615993mintier
mirier83918363_mirier
mitier83620673_mitier
modifier1446693modifier
nicer74618293_ni_cer
nicker123818703_nicker
niffers13287363_niffers
nifties102612503_nifties
nigger89713573_nigger
nigher103612753_nigher
nipper103715713_nipper
nippier11319833_nippier
niter55028973_ni_ter
nittier73512243_nittier
nixie125114943_nixie_
nixies135313873_nixies
noisier759453noisier
nosier63716323_nosier
notifier1137423notifier
nubbier11308133nubbier
nullifier1244333nullifier
nutsier7329253nutsier
nuttier73112023nuttier
oilier64417233_oilier
onerier7311613onerier
ossifier111196273ossifier
pacifier1557503pacifier
pinier84024693_pinier
pipier104913983_pipier
pitier84019823_pitier
pricier113313113pricier
privier122910453privier
puffier1547973puffier
punchier1536413punchier
punier84519223pun__ier
punisher1335773punisher
punkier133512793pun_kier
punnier93511263pun_nier
purified1438743purified
purifiers1435873purifiers
purifies13311923purifies
qualifier2145123qualifier
quantifier2243643quantifier
rainier71614253rainier
ratifier1139673ratifier
reefier102912553reefier
reified112913783reified
reifiers11309843reifiers
reifies104218283reifies
reunified1346593reunified
reunifies1247583reunifies
ribier84414233_ribier
rifer84721983_rif_er
rifler94014263_rifler
rimier83916273_rimier
roilier7311523roilier
runnier74010113run_nier
runtier73512853run_tier
shifter132911073shifter
shiftier1436333shiftier
shinier104113143shinier
sifter94516233_sifter
signifier1345713signifier
sizier1514813393_sizier
slimier93212013slimier
snakier112810003snakier
snicker133012673snicker
snider74413913sni_der
sniffed14318183sniffed
sniffers14257123sniffers
sniffler14296823sniffler
snifters11318603snifters
snigger9328373snigger
sniper84413643sni_per
snipper113911323snipper
snippier1255793snippier
snowier1038783snowier
snuffer13318843snuffer
snuffier14276933snuffier
spicier115112463spicier
spiffier16255883spiffier
spikier13369983spikier
spinier93715163spinier
spirier93214073spirier
stiffer13319393stiffer
stifler102911463stifler
sunnier73412153sun_nier
surfier102613543surfier
swifter13318053swifter
tidier73515113_tidier
tinier63622233_tinier
tinnier72910143tinnier
trifler103912153trifler
turfier10249793turfier
twinier1037313twinier
typifier1643403typifier
uglier748953u_glier
uglified1345293uglified
uglifiers1343093uglifiers
uglifies1246383uglifies
unbitter1046173unbitter
uncover1239003uncover
under64624213un__der
undies73821963un_dies
undoer73113043un_doer
undried92314613undried
uneager839753uneager
uneasier836963uneasier
unfair936233un_fair
unfairer11184283unfairer
unfed94614223un_f_ed
unfired112212453unfired
unfit84518563un_fi_t
unfits93910293un_fits
unfix15429033un_fi_x
unfixed18218563unfixed
unfixes17238113unfixes
unfixt16398423un_fixt
unfree9413203un_free
ungifted13116833ungifted
unhair937333unhai_r
unhairer11174993unhairer
unholier1137283unholier
uniface1236953uniface
unifaces1346393unifaces
uniform1247053uniform
uniformer1443633uniformer
unify113611113unif__y
unifying1537553unifying
unilinear942913unilinear
unionizer1844623unionizer
unique1558163unique_
uniques1667443uniques
unisex1358353uni_sex
unisize1647343unisize
unite54828383uni_te_
united74421543uni_ted
uniters73814173uni_ters
unites65024853uni_tes
uniting8315823uniting
unitive10310563unitive
unitize16310033unitize
unitized1839223unitized
unitizers1843923unitizers
unitizes1739133unitizes
unkinder1335363unkinder
unlimber1243373unlimber
unmaker13279513unmaker
unmiter9310393unmiter
unpitied1138783unpitied
unquiet16310663unquiet
unrifled1237423unrifled
unriper9188283unriper
unrulier845333unrulier
unsicker1435303unsicker
unsifted12128773unsifted
unsober967633unsober
untidied1038893untidied
untidies939813untidies
untie54425493un_tie_
untied73720813un_tied
unties64326923un_ties
untried82615853untried
untruer737113untruer
unwarier1136883unwarier
unwinder1235613unwinder
unwiser1037123unwiser
uplifter1363903uplifter
utiliser855243utiliser
utilizer1756193utilizer
veinier10269583veinier
verifier14159203verifier
vilifier1456693vilifier
vinier93716743_vinier
vinified1537543vinified
vinifies1439873vinifies
vivifier1745173vivifier
vizier184311023_vizier
whiffer19105323whiffer
whinier134110633whinier
whitier133311063whitier
wiftier13297733_wiftier
wilier93217073_wilier
windier113412163windier
wingier113413283wingier
winier94522453_winier
wirier94215553_wirier
zingier17369493zingier

Search took 7 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 Filter1786911340270.1701051123.5
2DLD Change Limit1340272975.87622809.2
3Display Results2972970.1102700.0
 (SQL Overall)1786912976.15629027.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.