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

152 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
unships123720(None) 
gunships1445171gunships
unship1148031unship_
gunship1345382gunship_
kinships1745792kinships
reships1239862reships
ships105123772__ships
sonships1357462sonships
unclips1136432unclips
unhip10178822un_hip_
unrips8199452un_rips
unshift1387422unshift
unshifts1444032unshifts
unsnaps935422unsnaps
unsteps936212unsteps
unstops936992unstops
unzips17175272un_zips
airships1347713airships
arshins10312573arshins
banshies131110663banshies
bishops1437033bishops
chips125721253__chips
chumships2143103chumships
dashis104414393dashi_s
deanships1545993deanships
enskies1138573enskies
godships1544723godships
gossips1035903gossips
gunshots1244373gunshots
guruships1542983guruships
hips96433703___hips
inclips1135963inclips
insteps936573insteps
instils7811453instils
kingships1943973kingships
kinship1645833kinship_
lashins103915153lashins
longships1544233longships
mashies12318253mashies
midships1645693midships
mishaps1438723mishaps
mishits122513083mishits
munchies1539253munchies
nihils937573_nihils
nips65830923_n__ips
palships1546213palships
preships1539313preships
pushups1433653pushups
queenships2452793queenships
reship11310673reship_
rishis9312453rishi_s
rosehips1344253rosehips
roshis9311793roshi_s
shies86136553__shies
shims104422553__shims
shins85131043__shins
ship95228243__ship_
shits84731173__shits
shivs115018803__shivs
shops104222903__shops
sips65740103__s_ips
skips115616603__skips
slips76023723__slips
snips75818013__snips
sonship12108653sonship_
sunshine1147923sunshine
sunshines1246583sunshines
sunshiny1445253sunshiny
sunsuits845963sunsuits
sushis9311183sushi_s
tankships1844643tankships
tinsnips1043733tinsnips
townships1744983townships
tranships14410333tranships
tushies10312163tushies
twinships1744123twinships
unais53420773un_ai_s
uncaps1039813un_caps
unchains1338303unchains
unchairs1345503unchairs
unchic1338643unchi_c
unclip1046993unclip_
uncoils979533uncoils
undies73821963un_dies
unfits93910293un_fits
unguis738453ungui_s
unhairs1036373unhairs
unhats91110623un_hats
unifies102714713unifies
unities72520153unities
units54923433un__its
unknits1135553unknits
unnails738223unnails
unpins82312383un_pins
unrigs7159003un_rigs
unrip72012863un_rip_
unripe82012093un_ripe
unsaid7411833unsai_d
unsays9399543uns_ays
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unsells73210773unsells
unsets64116163uns_ets
unsews9379363uns_ews
unsexes14248923unsexes
unshaped14148443unshaped
unshapen13155443unshapen
unsharp1235543unsharp
unshed10313773unsh_ed
unshell1047113unshell
unshells1145923unshells
unshipped1743863unshipped
unshod1067603unsh_od
unshorn1036943unshorn
unshowy1644173unshowy
unshut939013unsh_ut
unslick1356023unslick
unsling8313643unsling
unslings937283unslings
unsnags835463unsnags
unsnap836203unsnap_
unspilt938853unspilt
unstep839223unstep_
unstick1338123unstick
unsticks1436233unsticks
unstop837473unstop_
unstraps1045983unstraps
unswept1246013unswept
unthink1457003unthink
unthinks1574503unthinks
unties64326923un_ties
untrims938613untrims
unveils1045753unveils
unwhite1336813unwhite
unwits9389893un_wits
unwraps1255513unwraps
unzip16207623un_zip_
upmanships1953713upmanships
upshift1545113upshift
upshifts1642633upshifts
upshots1235193upshots
upsteps1133743upsteps
upstirs935293upstirs
urchins1238863urchins
ursids737823urs_ids
ushers94415533u_shers
usurps8105073u_surps
warships1647553warships
washups1534683washups
whips134917083__whips
worships1647103worships

Search took 8 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.406440125.6
2DLD Change Limit1340271526.56020430.9
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.02925422.0
 
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.