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

133 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
schooner133662(None) 
schooners1445661schooners
chooser124412972_chooser
crooner93714042_crooner
schmoozer25224362schmoozer
schooled1447042schooled
scooper113812032sc_ooper
scooter93312872sc_ooter
scorner9259762sc_orner
shooter103013992s_hooter
sooner64220462s__ooner
swooner10358672s_wooner
actioner1048663actioner
choicer14197893_choicer
choker154314373_ch_oker
chokier1638043_chokier
choler113717153_ch_oler
chomper163810073_chomper
choose115116143_choose_
choosers134810873_choosers
chooses125717423_chooses
choosey15459233_choosey
choosier1337173_choosier
chopper163611893_chopper
chouser125212943_chouser
chowder16387803_chowder
churner12298343_churner
cloner84418093_c_loner
coiner84323783_c_oiner
conner84423963_c_onner
cooer74831013_c_oo_er
cooker124722453_c_ooker
cooler84824713_c_ooler
cooper104221123_c_ooper
cooter85128613_c_ooter
corner84625623_c_orner
coroner94218203_coroner
crooker134111093_crooker
crooned103813343_crooned
crooners103911393_crooners
crowner124012593_crowner
dehorner1235523dehorner
echoer114011103ech_o_er
honer85332093__h_oner
hoofer124014953__hoofer
hooker134820173__hooker
hooper114518313__hooper
hooter94123933__hooter
hoover124314433__hoover
mooner85317833__mooner
ochone11311293och_one_
ratooner887003ratooner
scanner94411813sc_anner
schemer1477953sch_emer
schiller13296473schiller
schizier2234063schizier
schmeer1475363sch_meer
schmoe13328333schmo_e_
schmoes14308543schmo_es
schmoose15295973schmoose_
schmoosed17294303schmoosed
schmooses16275633schmooses
schmooze24255013schmooze_
schmoozed26244133schmoozed
schmoozers26223263schmoozers
schmoozes25214903schmoozes
schmoozier26262283schmoozier
schnorrer1442703schnorrer
schnozes2244493schnozes
scholar1236953sch_olar
school11410723schoo__l
schoolmen1643473schoolmen
schools1249113schoo_ls
schusser1342973schusser
scoffer15317023sc_offer
scolder103210333sc_older
scone74621833sc__one_
scones84521303sc__ones
scooped124611743sc_ooped
scoopers124210193sc_oopers
scooted103612283sc_ooted
scooters103511033sc_ooters
scorer84818253sc__orer
scorned10229953sc_orned
scorners10228493sc_orners
scoter83815483sc__oter
scourer93910433sc_ourer
scouter93313323sc_outer
scowder13286853sc_owder
scowler12248173sc_owler
screener1037563screener
scrooge1037173scrooge_
scrooges1137163scrooges
scrooped1356403scrooped
scrounger1243443scrounger
scunner9358243sc_unner
seasoner857693seasoner
shiner93820873s_h_iner
shoaler102610083s_hoaler
shocker163411433s_hocker
shoer84722163s_h_o_er
shone83725983s_h_one_
shooed103916083s_hoo_ed
shooled115212663s_hooled
shoon84022013s_hoon__
shooters112811583s_hooters
shopper143312633s_hopper
shorter103515503s_horter
shouter103213083s_houter
shover124515993s_h_over
shower124315113s_h_ower
showier1339103s_howier
shunner10358643s_hunner
snooker113910303s_nooker
snooper93511533s_nooper
snoozer16409193s_noozer
sooners73916643s__ooners
sorner64720393s__orner
spoofer12368723s_poofer
spooler93711383s_pooler
spooned103412443s_pooned
spooney12418243s_pooney
spoonier10167653s_poonier
stoner65823203s__toner
stooker113811733s_tooker
stooper93813193s_tooper
suborner1047383suborner
summoner1245533summoner
swooned11368593s_wooned
swooners11336863s_wooners
swoonier11185133s_woonier
swooper12389173s_wooper
whooper15297153_whooper

Search took 9 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 Limit1461621338.03018202.0
3Display Results1331330.0502660.0
 (SQL Overall)1786911338.23621696.3
 
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.