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

157 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
santoors83763(None) 
santoor737431santoor_
santours837181santours
cantors94620752cant_ors
pandoors11258982pandoors
santeros8311192santeros
santirs7312962sant_irs
santols73513322sant_ols
santos64421832sant_o_s
santour737372santour_
santurs7310762sant_urs
sartors7314952sart_ors
sautoirs834922sautoirs
tandoors9258052tandoors
actors81016763_act_ors
anchors123912953_anchors
anthers103715203_anthers
antiars7314623_antiars
antlers74014743_antlers
antrorse846923_antrorse
authors10311843_authors
banters94623113bant_ers
candors104216763can_dors
candours11408643candours
canoers94318373can_oers
cantdogs1244043cantdogs
canters94827733cant_ers
cantons95221203cant_ons
cantor85621523cant_or_
cantos84826973cant_o_s
captors113914983capt_ors
cartoons104012803cartoons
castors94919433cast_ors
chantors133710263chant_ors
contours1039643contours
factors12912123fact_ors
faitours1134263faitours
fantods11177623fant_ods
fantoms12189153fant_oms
gators74115833ga_t_ors
gentoos838633gentoo_s
grantors93810353grant_ors
haftoros1444173haftoros
indoors838553_indoors
janitors1536853janitors
kantars11310033kant_ars
languors976153languors
lanthorn1147193lanthorn
lanthorns1246013lanthorns
manhoods1447243manhoods
manors84420883man__ors
mentors9314993ment_ors
pandoor10358583pandoor_
pandours11317993pandours
panthers13510783panthers
pantos85222743pant_o_s
pantoums1236713pantoums
pastors94118993past_ors
pontoons10279313pontoons
rancors9811373ran_cors
rancours1076713rancours
ranters73323643rant_ers
raptors94213353rapt_ors
ratoons73815473ra_toons
rattoons8327513rattoons
sailors73213723sa_ilors
saintdoms1242493saintdoms
sainthoods1453453sainthoods
saloons74415313sa_loons
saloops93510133sa_loops
salters73622253salt_ers
saltiers83411953saltiers
saltwork1545533saltwork
saltworks1645173saltworks
saltwort1148593saltwort
saltworts1244643saltworts
salvors103910913sa_lvors
sanctions1138873sanctions
sandbars11108783sandbars
sandburs11105623sandburs
sanders84025943san_ders
sandhogs1365483sandhogs
sandlots938293sandlots
sandworm1446323sandworm
sandworms1545633sandworms
sandwort12410073sandwort
sandworts1346443sandworts
sangars83116253san_gars
sangers84421943san_gers
sanious7514103san_ious
sannops936693san_nops
sansars73313913san_sars
santalols944773santalols
santera7311303sant_era
santeras8311063santeras
santero7311133sant_ero
santims9312593sant_ims
santir6315243sant_ir_
santo56227283sant_o__
santol64515243sant_o_l
santonin849693santonin
santonins948453santonins
santur6311273sant_ur_
sapors84118813sa__pors
sapours93610623sa_pours
sapwoods1456263sapwoods
sartor6313873sart_or_
satori6415833sa_t_ori
satoris7317233sa_toris
satyrs937963sa_t_yrs
saunters82911753saunt_ers
sautoir735173sautoir_
sautoire844493sautoire
sautoires944793sautoires
saviors1058993sa_viors
saviours1154273saviours
savors95616103sa__vors
savours10389343sa_vours
sawtooth1442723sawtooth
seafloors1243043seafloors
sectors93116433sect_ors
senators8312943senators
senhors103512123sen_hors
seniors73413613sen_iors
senors63620783sen__ors
sensors73514623sen_sors
settlors8255013settlors
shnooks1485573shn_ooks
sinters74024083sint_ers
snoods74312443s_n_oods
snooks104412823s_n_ooks
snools65715873s_n_ools
snoops84314163s_n_oops
snoots64216663s_n_oots
sonhoods1247083sonhoods
spontoons1153393spontoons
spoors84014023s__poors
stators73915563stat_ors
stentors839723stent_ors
stooks105115373s__tooks
stools65117023s__tools
stoops85917893s__toops
stours65015633s__tours
suitors73012483suit_ors
sunroofs1144763sunroofs
sunrooms1045723sunrooms
tandoor8278563tandoor_
tandoori9244773tandoori
tandooris10224633tandooris
tattooers943633tattooers
tattoos738643tattoo_s
unmoors945903_unmoors
vanpools1343193vanpools
wanters104420093want_ers
wantoners12116673wantoners
wantons103713013want_ons
xanthous1846633xanthous

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621577.68619016.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.90522604.8
 
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.