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

239 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
unzips1717527(None) 
unrips8199451unrips
unzip16207621unzip_
nips65830922_n_ips
snips75818012sn_ips
unais53420772unai_s
uncaps1039812uncaps
unclips1136432unclips
undies73821962undies
unfits93910292unfits
unhip10178822unhip_
units54923432un_its
unpins82312382unpins
unrigs7159002unrigs
unrip72012862unrip_
unripe82012092unripe
unships1237202unships
unties64326922unties
unwits9389892unwits
zips155723792__zips
anils56326723an_ils
anis45746463an_i_s
antics84621453antics
antis55033313anti_s
anvils9219713anvils
aunties73920073aunties
benzins1838693benzins
bezils1711310603bezils
blips95615783_blips
bunnies94415003bunnies
chips125721253_chips
clips96018303_clips
cozies174521413cozies
dips75536913__dips
drips85417233_drips
dunlins849553dunlins
envies9314053envies
enzyms2063433enzyms
equips17387193equips
flips105117743_flips
funkias1435383funkias
funnies104113603funnies
fuzils18407963fuzils
genips9469943genips
gips75632923__gips
gneiss765953gneiss
grips85520133_grips
gunnies83413123gunnies
gunships1445173gunships
hips96433703__hips
hunkies143214503hunkies
inclips1135963inclips
indies73822783indies
intis55121643inti_s
junkies183711693junkies
kips106430513__kips
knaps115511173kn_aps
knits93914743kn_its
knops115911813kn_ops
knosps12405013knosps
kunzite2053503kunzite
kunzites2143243kunzites
lazies154418783lazies
lips67141443__lips
lungis77113023lungi_s
lunies64723013lun_ies
mips85534083__mips
munis75022003mun_i_s
muntins92715133muntins
naifs87617423_naifs
nails55730403_nails
naps66238583_n_aps
nazis145216083nazi_s
neaps75618323_neaps
neeps75617883_neeps
neifs85613043_neifs
nibs65028313_n_ibs
nils46132453_n_ils
nims66226883_n_ims
nip56945983_n_ip_
nipa69421633_n_ipa
nipas77116673_n_ipas
nits45741643_n_its
noils55024333_noils
noirs55615463_noirs
nubias8310093nubias
nudies75217093nudies
nuncios937113nuncios
oxlips1544433oxlips
pips85837133__pips
pundits10379293pundits
punjis1536693punji_s
punkies134216803punkies
punkins133111113punkins
punties94520783punties
quips164713373_quips
redips93713843redips
rips66237433__rips
scrips105316033scrips
ships105123773_ships
sips65740103__sips
skips115616603_skips
slips76023723_slips
snails64816653snails
snaps74719563sn_aps
sneaps84510863sneaps
snibs75613763sn_ibs
snip66424653sn_ip_
snipe75320573sn_ipe
snipes83917393sn_ipes
snits54124833sn_its
snoops84314173snoops
sozins15510793sozins
strips85719653strips
sunups837263sun_ups
thrips11299013thrips
tips66436763__tips
trips74923363_trips
tulips8137253tulips
tuneups933333tuneups
tunics83811263tun_ics
tunnies73614263tunnies
turnips935013turnips
uglies7412323uglies
umps85721943u__mps
unai44824783unai__
unapt710421593un_apt
unarms839243unarms
unaus53216573un_aus
unbans81912623unbans
unbars82113033unbars
unbid83214643unbi_d
unbind93011433unbind
unbinds10267353unbinds
uncap9312283uncap_
unci65019463unci__
uncia75015163unci_a
unciae83215313unciae
uncial83715223uncial
uncials92510523uncials
uncini8310153uncini
uncinus937403uncinus
uncles8317163uncles
unclip1046993unclip_
uncoils979533uncoils
uncos74117033un_cos
uncus74014983un_cus
undid72415363undi_d
undine7817263undine
undines8716083undines
undoes73917403undoes
unfit84518563unfi_t
unfix15429033unfi_x
unfixes17238113unfixes
unfixt16398423unfixt
ungird887973ungird
ungirds9105303ungirds
ungirt71112713ungirt
ungues7412123ungues
unguis738453unguis
unhairs1036373unhairs
unhats91110623unhats
unifies102714713unifies
unify113611113un_ify
union54519793un_ion
unions64216753unions
unipod946853un_ipod
unipods1095703un_ipods
unit45140073un_i_t
unite54828383un_ite
unites65024853unites
unities72520153unities
unity84918493un_ity
unjams1555703unjams
unkept123710873unkept
unkind113310573unkind
unkink9308713unkink
unkinks10265413unkinks
unknits1135553unknits
unlays93810493unlays
unless62413073unless
unlike102614063unlike
unlink104011013unlink
unlinks11307403unlinks
unlit55025463unli_t
unlive92712333unlive
unlives102010953unlives
unmans82211993unmans
unmews11326523unmews
unmix14388973unmi_x
unmixes16197753unmixes
unmixt15378703unmixt
unnails738223unnails
unpegs9256233unpegs
unpens82511013unpens
unpick1446903unpick
unpicks1545183unpicks
unpile81914323unpile
unpiles92112783unpiles
unpin72613243unpi_n
unrig61711413unri_g
unriper9188283unriper
unripest1046083unripest
uns35936753un___s
unsays9399543unsays
unsets64116163unsets
unsews9379363unsews
unship1148033unship_
unsnaps935423unsnaps
unsteps936213unsteps
unstops936993unstops
untidy1059153untidy
untie54425493unti_e
untied73720813untied
until53517743unti_l
untrims938613untrims
unveils1045753unveils
unwept11389813unwept
unwind102610543unwind
unwinds11286733unwinds
unwise9510803unwise
unwish1239093unwish
unwit84417523unwi_t
unwraps1255513unwraps
unzipped2233213unzipped
ups55629053u___ps
urbias839093urbias
urps66920473u__rps
ursids737823ursids
usurps8105073usurps
vizirs18306713vizirs
whips134917083_whips
yips95226703__yips
zaps156826893__zaps
zeps156019343__zeps
zigs145422793__zigs
zins135735003__zins
zip146636223__zip_
zits136030293__zits

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.376475242.0
2DLD Change Limit1127162394.75023729.7
3Display Results2392390.0763144.7
 (SQL Overall)1786912395.20234350.4
 
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.