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 “unfix” 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
unfix1542903(None) 
infix15337771infix
unfit84518561unfit
unfixt16398421unfixt
unmix14388971unmix
affix1836002affix
fix136236102__fix
nix106932832_n_ix
refix155212482refix
subfix1835072subfix
suffix1935232suffix
unai44824782unai_
unais53420772unais
unbid83214642unbid
unbox1438752unbox
unci65019462unci_
uncia75015162uncia
undid72415362undid
unfair936232unfair
unfed94614222unfed
unfits93910292unfits
unfixed18218562unfixed
unfixes17238112unfixes
unhip10178822unhip
unific1137462unific
unify113611112unify
unit45140072un_it
unlit55025462unlit
unmixt15378702unmixt
unpin72613242unpin
unrig61711412unrig
unrip72012862unrip
unsex123512632unsex
untie54425492untie
until53517742until
unwit84417522unwit
unzip16207622unzip
admix1557733admix
ani37751183an_i_
anil46437433an_il
anis45746463an_is
annex12310883annex
antefix1745053antefix
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
auntie64317703auntie
befit105222663befit
bemix165011453bemix
bifid11910703bifid
buffi136112203buffi_
calix145317353calix
comix163513203comix
confit113316403confit
cylix17448623cylix
defi86321493defi_
defis96717503defis
dunlin739723dunlin
elfin84312463elfin
entia5318203entia
fanfic1436313fanfic
fax138143313__fax
fib86344273__fib
fid76847683__fid
fie67152443__fie
fig76242833__fig
fil65447143__fil
fin66458033__fin
fir66744893__fir
fit66365453__fit
fixt1410729713__fixt
fiz156238763__fiz
fox136737863__fox
fulfil1246423fulfil
fundi96814913fundi_
fundic12389083fundic
funfair1342033funfair
fungi95014133fungi_
fungic12387813fungic
funkia1336343funkia
gunfire1134743gunfire
hafiz20611213hafiz
helix154413013helix
hunkie133812383hunkie
immix1635033immix
index13310983index
indie63721473indie
infer84215033infer
infill938413infill
infirm1137043infirm
infixed18206563infixed
infixes17238133infixes
influx1643723influx
info75617353inf_o
infos84311673infos
infra838643infra
inia45024703in_ia
inti46626083inti_
intis55121643intis
junkie17339603junkie
kafir12488903kafir
kefir12457913kefir
knife1210010133knife
knit85728143kn_it
kufi11910653kufi_
kufis1249253kufis
kylix19416323kylix
lungi65516053lungi_
lungis77113023lungis
mafia104418033mafia
mafic125615463mafic
mix126138183__mix
muffin14298873muffin
muni65824413mun_i_
munis75022003mun_is
muntin82915183muntin
naif76839023_naif
nail45838653_nail
neif75429493_neif
nib56745193_n_ib
nil36144193_n_il
nim57142953_n_im
nip56945983_n_ip
nit37065943_n_it
nixe115722023_n_ixe
nixy145714513_n_ixy
noil46133243_noil
noir46722433_noir
nubia7311233nubia
nudie65118673nudie
nuncio837973nuncio
ontic74418573ontic
onyx1478363on_yx
outfit93014953outfit
outfox1636143outfox
pix126437933__pix
prefix18356853prefix
puffin141149003puffin
pundit92914183pundit
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
radix134414603radix
refit84230063refit
remix145916553remix
runic73615773run_ic
six105339743__six
snail57020203snail
snib66522983sn_ib
sniff113915863sniff
snip66424653sn_ip
snit46342473sn_it
sulfid1039063sulfid
sunfish1338883sunfish
sunlit61516103sunlit
tafia84215493tafia
tunic74018223tun_ic
un28341133un___
unakin10310963unakin
unapt710421593unapt
unarm7314453unarm
unary8315993unary
unau43924153un_au
unaus53216573unaus
unban72114333unban
unbar71913613unbar
unbe65319273un_be
unbind93011433unbind
uncap9312283uncap
unchic1338643unchic
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
uncle7317053uncle
unclip1046993unclip
unco66021403un_co
uncoil8811853uncoil
uncos74117033uncos
uncoy104111413uncoy
uncus74014983uncus
uncut73219173uncut
unde55825483un_de
undee65327273undee
under64624213under
undies73821963undies
undine7817263undine
undo55620153un_do
undue66715553undue
undy85015163un_dy
unfaith1345783unfaith
unfelt92413463unfelt
unfired112212453unfired
unfitly1335573unfitly
unfixing1935683unfixing
unfold10179703unfold
unfond10149113unfond
unfree9413203unfree
unfurl937953unfurl
ungird887973ungird
ungirt71112713ungirt
ungot61718063ungot
unguis738453unguis
unhair937333unhair
unhat81119263unhat
unified112413573unified
unifier102211863unifier
unifies102714713unifies
union54519793union
unisex1358353unisex
unite54828383unite
units54923433units
unity84918493unity
unjam1448723unjam
unkind113310573unkind
unkink9308713unkink
unknit1068593unknit
unlaid7311753unlaid
unlay84613703unlay
unled64021073unled
unlet54133333unlet
unlike102614063unlike
unlink104011013unlink
unlive92712333unlive
unman72715423unman
unmet74426393unmet
unmew103610073unmew
unmixed17228213unmixed
unmixes16197753unmixes
unnail6410583unnail
unpaid939473unpaid
unpeg8309363unpeg
unpen72913573unpen
unpick1446903unpick
unpile81914323unpile
unpins82312383unpins
unrigs7159003unrigs
unripe82012093unripe
unrips8199453unrips
uns35936753un__s
unsaid7411833unsaid
unsay83212843unsay
unset54532433unset
unsew83912693unsew
unsexy16296903unsexy
unship1148033unship
untidy1059153untidy
untied73720813untied
unties64326923unties
unto45824283un_to
untrim8310683untrim
unveil957343unveil
unvext1658173unvext
unwed94114873unwed
unwet84423173unwet
unwind102610543unwind
unwise9510803unwise
unwish1239093unwish
unwits9389893unwits
unwon84512343unwon
unzips17175273unzips
uplit76020803uplit
urbia7311143urbia
ureic74514463ureic
uric63624933u_ric
ursid6311483ursid
varix154313513varix

Search took 5 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.1101624463.6
2DLD Change Limit836672684.67017915.8
3Display Results2682680.0803350.0
 (SQL Overall)1786912684.86036767.7
 
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.