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

268 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
infix1533777(None) 
unfix15429031unfix
affix1836002affix
fix136236102__fix
immix1635032immix
index13310982index
indie63721472indie
infer84215032infer
infill938412infill
infirm1137042infirm
infixed18206562infixed
infixes17238132infixes
influx1643722influx
info75617352inf_o
infos84311672infos
infra838642infra
inia45024702in_ia
inti46626082inti_
intis55121642intis
nix106932832_n_ix
refix155212482refix
unfit84518562unfit
unfixt16398422unfixt
unmix14388972unmix
admix1557733admix
ani37751183an_i_
anil46437433an_il
anis45746463an_is
annex12310883annex
antefix1745053antefix
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
befit105222663befit
bemix165011453bemix
biffin14369103biffin
bifid11910703bifid
bindi85617013bindi_
bindis94614583bindis
binit76431583bin_it
calix145317353calix
comix163513203comix
confit113316403confit
cylix17448623cylix
defi86321493defi_
defis96717503defis
elfin84312463elfin
entia5318203entia
fanfic1436313fanfic
fax138143313__fax
fib86344273__fib
fid76847683__fid
fie67152443__fie
fig76242833__fig
fil65447143__fil
fin66458033__fin
finfish16268193finfish
finis86824263fin_is
fir66744893__fir
fit66365453__fit
fixt1410729713__fixt
fiz156238763__fiz
fox136737863__fox
hafiz20611213hafiz
helix154413013helix
ibex133813483i_bex
ibis66519583i_bis
ictic9311803ictic
if57239953i_f__
iff96730393i_f_f
iffier1236763iffier
iffy135312283i_ffy
ifs67124243i_f_s
ignify1334513ignify
ilex115822033i_lex
ilia46026823i_lia
imid76122293i_mid
impi85415793impi_
impis96213853impis
in28150863in___
inane52820343inane
inapt73522693inapt
inarm7314423inarm
inby95315663in_by
inbye10427063inbye
inch95420823in_ch
incise83515333incise
incite83618733incite
inclip1036823inclip
incog838253incog
incur72212253incur
incus73315053incus
indict93115573indict
indies73822783indies
indign8308473indign
indigo8388023indigo
indite73520323indite
indium939503indium
indol63714873indol
indow95011663indow
indri6310793indri
indris7311963indris
indue63516673indue
inept73622153inept
inert53234373inert
infall939403infall
infamy1435653infamy
infant92315133infant
infare9313083infare
infect113413443infect
infers93615443infers
infest93315433infest
infidel1146043infidel
infield1135823infield
infight1437453infight
infirms1245563infirms
infixing1936103infixing
infixion1843683infixion
inflict1248623inflict
inflow1235293inflow
infold10128163infold
inform11310153inform
infuse93110573infuse
ingle64120433ingle
ingot61221063ingot
inion54620183inion
ink76433633in__k
inked104218523inked
inker94421093inker
inkier104013783inkier
inking115119053inking
inkle94515833inkle
inks86926503in_ks
inky115321583in_ky
inlaid7310143inlaid
inlay85214323inlay
inlet53732403inlet
inlier63615363inlier
inly75622213in_ly
inn36727433in__n
inned64118423inned
inner54920633inner
inning73617633inning
inns46920933in_ns
input7314653input
inro45920793in_ro
inrun52911373inrun
ins35945603in__s
inset54430863inset
inside7613453inside
insist6314513insist
instil61111383instil
inter55028493inter
intima81910033intima
intime81014273intime
intine61021983intine
into45026153in_to
intro54915853intro
intuit6314083intuit
inulin6311733inulin
inure54119053inure
inurn53712863inurn
invar839513invar
invite93715033invite
inwind10268413inwind
iodic84816753iodic
iodid74315533iodid
iodin64419353iodin
ionic74622663ionic
irid55927173i_rid
iris45732553i_ris
iwis77117013i_wis
ixia115713213i_xia
jinni125310633jinni_
jinnis13489053jinnis
jinx185516573jin__x
kafir12488903kafir
kefir12457913kefir
kinin94917323kin_in
knife1210010133knife
knit85728143kn_it
kufi11910653kufi_
kufis1249253kufis
kylix19416323kylix
linin58025523lin_in
mafia104418033mafia
mafic125615463mafic
mini65634563min_i_
minify1439253minify
minim97321603min_im
minis75432993min_is
minx137723353min__x
misfit112813833misfit
mix126138183__mix
naif76839023_naif
nail45838653_nail
neif75429493_neif
nib56745193_n_ib
nidi56524393nidi_
nifty115211633nifty
nihil8410283nihil
nil36144193_n_il
nim57142953_n_im
nip56945983_n_ip
nisi45823243nisi_
nit37065943_n_it
nitid61817833nitid
nixe115722023_n_ixe
nixie125114943nixie
nixy145714513_n_ixy
noil46133243_noil
noir46722433_noir
ontic74418573ontic
onyx1478363on_yx
pinfish15319303pinfish
pinkie124414273pinkie
pinyin112710613pinyin
pix126437933__pix
prefix18356853prefix
radix134414603radix
refit84230063refit
remix145916553remix
sinful938803sinful
six105339743__six
snail57020203snail
snib66522983sn_ib
sniff113915863sniff
snip66424653sn_ip
snit46342473sn_it
subfix1835073subfix
suffix1935233suffix
tafia84215493tafia
tiffin12327933tiffin
tineid74412023tineid
tinfoil1044633tinfoil
tinful938043tinful
unai44824783unai_
unais53420773unais
unbid83214643unbid
unbox1438753unbox
unci65019463unci_
uncia75015163uncia
undid72415363undid
unfair936233unfair
unfed94614223unfed
unfits93910293unfits
unfixed18218563unfixed
unfixes17238113unfixes
unhip10178823unhip
unific1137463unific
unify113611113unify
unit45140073un_it
unlit55025463unlit
unmixt15378703unmixt
unpin72613243unpin
unrig61711413unrig
unrip72012863unrip
unsex123512633unsex
untie54425493untie
until53517743until
unwit84417523unwit
unzip16207623unzip
varix154313513varix
vinic10314973vin_ic
vinify1536923vinify
zincic1935903zincic
zinnia1536013zinnia

Search took 4 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 Filter178691836670.330541487.9
2DLD Change Limit836672683.39024680.5
3Display Results2682680.0604466.7
 (SQL Overall)1786912683.78047272.8
 
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.