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

258 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
unzip1620762(None) 
unhip10178821unhip
unrip72012861unrip
unzips17175271unzips
nip56945982_n_ip
snip66424652sn_ip
unai44824782unai_
unais53420772unais
unbid83214632unbid
uncap9312282uncap
unci65019462unci_
uncia75015162uncia
unclip1046992unclip
undid72415362undid
unfit84518562unfit
unfix15429032unfix
unit45140072un_it
unlit55025462unlit
unmix14388972unmix
unpin72613242unpin
unrig61711412unrig
unripe82012092unripe
unrips8199452unrips
unship1148032unship
untie54425492untie
until53517742until
unwit84417522unwit
zip146636222__zip
ani37751173an_i_
anil46437433an_il
anis45746463an_is
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
atrip75315743atrip
auntie64317703auntie
benzin1738933benzin
bezil163812883bezil
blip88322773_blip
chip116726423_chip
clip86924003_clip
cozie163519123cozie
dip67848983__dip
drip76223953_drip
dunlin739723dunlin
entia5318203entia
enzym1964393enzym
equip16467263equip
flip96324263_flip
fundi96814913fundi_
fundic12389083fundic
fungi95014133fungi_
fungic12387813fungic
funkia1336343funkia
fuzil173810703fuzil
genip84415203genip
gip67645363__gip
grip76127023_grip
gunship1345383gunship
hip86750433__hip
hunkie133812383hunkie
inclip1036813inclip
indie63721463indie
infix15337763infix
inia45024693in_ia
inti46626073inti_
intis55121633intis
junkie17339603junkie
kip97042133__kip
knap105815403kn_ap
knit85728143kn_it
knop107116593kn_op
knosp11576823knosp
kunzite2053503kunzite
lip514755803__lip
lungi65516053lungi_
lungis77113023lungis
muni65824403mun_i_
munis75022003mun_is
muntin82915183muntin
naif76839013_naif
nail45838653_nail
nap56753203_n_ap
nazi136219873nazi_
nazis145216083nazis
neap66927013_neap
neep65728313_neep
neif75429483_neif
nib56745183_n_ib
nil36144193_n_il
nim57142953_n_im
nipa69421633_n_ipa
nips65830923_n_ips
nit37065943_n_it
nix106932833_n_ix
noil46133243_noil
noir46722433_noir
nubia7311223nubia
nudie65118673nudie
nuncio837963nuncio
ontic74418573ontic
oxlip1456883oxlip
pip78051043__pip
pundit92914183pundit
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
quip154818623_quip
redip87816963redip
rip56851303__rip
runic73615773run_ic
scrip96619193scrip
ship95228233_ship
sip57656013__sip
skip105421743_skip
slip67031733_slip
snail57020203snail
snap65727033sn_ap
sneap75514823sneap
snib66522973sn_ib
snipe75320573sn_ipe
snips75818013sn_ips
snit46342473sn_it
snoop75317173snoop
sozin14514523sozin
strip77524333strip
sunlit61516103sunlit
sunup7313053sun_up
thrip103012183thrip
tip56551223__tip
trip66830393_trip
tulip71111693tulip
tuneup835203tuneup
tunic74018223tun_ic
turnip836593turnip
ump76130443u__mp
un28341133un___
unakin10310963unakin
unapt710421593unapt
unarm7314453unarm
unary8315993unary
unau43924153un_au
unaus53216573unaus
unban72114333unban
unbar71913613unbar
unbe65319273un_be
unbind93011423unbind
unbox1438753unbox
uncaps1039813uncaps
unchic1338633unchic
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
uncle7317053uncle
unclips1136433unclips
unco66021403un_co
uncoil8811853uncoil
uncos74117033uncos
uncoy104111413uncoy
uncus74014983uncus
uncut73219173uncut
unde55825483un_de
undee65327273undee
under64624213under
undies73821963undies
undine7817263undine
undo55620153un_do
undue66715553undue
undy85015163un_dy
unfair936233unfair
unfed94614223unfed
unfits93910293unfits
unfixt16398423unfixt
ungird887973ungird
ungirt71112713ungirt
ungot61718063ungot
unguis738443unguis
unhair937333unhair
unhat81119263unhat
unific1137463unific
unify113611113unify
union54519793union
unipod946853un_ipod
unite54828383unite
units54923433units
unity84918493unity
unjam1448723unjam
unkept123710873unkept
unkind113310573unkind
unkink9308713unkink
unknit1068593unknit
unlaid7311753unlaid
unlay84613703unlay
unled64021073unled
unlet54133333unlet
unlike102614063unlike
unlink104011013unlink
unlive92712333unlive
unman72715423unman
unmet74426393unmet
unmew103610073unmew
unmixt15378703unmixt
unnail6410583unnail
unpaid939473unpaid
unpeg8309363unpeg
unpen72913573unpen
unpick1446903unpick
unpile81914323unpile
unpins82312383unpins
unrigs7159003unrigs
unriper9188283unriper
uns35936753un__s
unsaid7411833unsaid
unsay83212843unsay
unset54532433unset
unsew83912693unsew
unsex123512633unsex
unships1237203unships
unsnap836203unsnap
unstep839223unstep
unstop837473unstop
untidy1059153untidy
untied73720813untied
unties64326923unties
unto45824283un_to
untrim8310673untrim
unveil957343unveil
unwed94114873unwed
unwept11389813unwept
unwet84423173unwet
unwind102610543unwind
unwise9510803unwise
unwish1239093unwish
unwits9389893unwits
unwon84512343unwon
unwrap11126323unwrap
unzipped2233213unzipped
up47832823u___p
uplit76020803uplit
urbia7311133urbia
ureic74514463ureic
uric63624933u_ric
urp56426393u__rp
ursid6311483ursid
usurp7106903usurp
vizir17359393vizir
whip125521843_whip
yip87241173__yip
zap145840693__zap
zep147129143__zep
zig136931903__zig
zin125643773__zin
zips155723793__zips
zit126049993__zit
zizit13313273zizit
zuzim1534863zuzim

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.1431249587.4
2DLD Change Limit836672583.85621697.9
3Display Results2582580.0634095.2
 (SQL Overall)1786912584.06243990.9
 
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.