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 “softs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

214 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
softs8501923(None) 
lofts85518361lofts
sifts84918921sifts
sofas85320711sofas
soft76942821soft_
softa86415181softa
softas94410401softas
softy115414481softy
soots55536201soots
sorts54536661sorts
sots45552441so_ts
tofts84919241tofts
boats75635152boats
boffs134915502boffs
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
coats75634992coats
coffs134916302coffs
coft97939682coft_
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
crofts114910592crofts
doats65224882doats
doffs125614332doffs
doits66223672doits
dolts65626312dolts
dots55647662do_ts
efts76519482_efts
fonts86124752fonts
foots85528282foots
forts86034452forts
gifts96214962gifts
goats65527302goats
gouts64826172gouts
hafts116219462hafts
hefts116218152hefts
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
jolts125018882jolts
jots116336142jo_ts
lefts86517812lefts
lifts85719062lifts
loft76539142loft_
lofty115813302lofty
loots55431422loots
lots47652092lo_ts
louts56330272louts
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
nowts86915852nowts
oats46554212_oats
offs107117012_offs
oft67744062_oft_
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
rafts87820632rafts
rifts85718642rifts
roots55933672roots
rots46454092ro_ts
routs57133412routs
safes85226722safes
salts55431882salts
scats75930602scats
scoffs14347502scoffs
scoots85315932scoots
scots74025902scots
scouts84817942scouts
scuts74522522scuts
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shafts125411432shafts
shifts124412932shifts
shits84731162shits
shoats94117072shoats
shoots94619342shoots
shorts95321732shorts
shots84730832shots
shotts93614682shotts
shouts94017712shouts
shuts85622472shuts
sift710740662sift_
silts55330822silts
sits45050202s_its
skats94621532skats
skits94721852skits
skorts104211292skorts
slats55436902slats
slits56128852slits
slots54830522slots
sluts54523982sluts
smolts84411882smolts
smuts75415712smuts
snits54124832snits
snoots64216662snoots
snorts64116492snorts
snots55225102snots
snouts64915862snouts
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sobas74424252sobas
sobs64941752so_bs
socas74026182socas
socks114926082socks
sodas64123542sodas
sods54940212so_ds
sofa75625602sof_a
sofar86115492sofar
sofars94712782sofars
soffits1335092soffits
soften9429492soften
softens10347622softens
softer94015312softer
softest10310602softest
softie93312472softie
softies103414612softies
softish13127812softish
softly12457762softly
soils55327982soils
sojas124716392sojas
sokes95031422sokes
soles55547922soles
solos54830792solos
sols45448162so_ls
solus54726982solus
somas76030372somas
soms66239372so_ms
sones55444142sones
songs67725552songs
sons46049552so_ns
sooks94425452sooks
soot45761052soot_
sooth85924052sooth
sooths95715582sooths
sooty84924832sooty
sophs104916022sophs
sops65244562so_ps
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028412sorns
sort46264812sort_
sorta57125412sorta
sorus54527582sorus
sos37761602so__s
sot310384292so_t_
soth75932512so_th
soths86218622soths
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212so_us
south85223572south
souths95216602souths
sows75342492so_ws
soyas84520912soyas
soys75233932so_ys
spats75031382spats
spits74429552spits
sports84619182sports
spots74424102spots
spouts85115112spouts
stats55933362stats
stets55423912stets
stoats65117482stoats
stots54828542stots
stotts64612852stotts
stouts65019002stouts
suets55126102suets
suits55028052suits
swats85726862swats
swifts12408172swifts
swots85518422swots
toffs116016722toffs
toft77441652toft_
tofus86415422tofus
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
tufts85713272tufts
volts85421292volts
wafts116920552wafts
wefts116715492wefts
wonts87621542wonts
worts88631182worts
wots76342892wo_ts

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002141.82629463.3
3Display Results2142140.0633396.8
 (SQL Overall)1786912141.98290156.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.