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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
schooners144566(None) 
schooner1336621schooner_
choosers134810872_choosers
crooners103911392_crooners
schmoozers26223262schmoozers
scoopers124210192sc_oopers
scooters103511032sc_ooters
scorners10228492sc_orners
shooters112811582s_hooters
sooners73916642s__ooners
swooners11336862s_wooners
actioners1147723actioners
chokers164311523_ch_okers
cholers124215203_ch_olers
chompers17369593_chompers
chooser124412973_chooser_
chooses125717423_choose_s
choppers174110463_choppers
chousers134610203_chousers
chowders17387543_chowders
churners13316893_churners
cloners94514823_c_loners
coiners93620753_c_oiners
conners94023113_c_onners
cooers84324563_c_oo_ers
cookers134619463_c_ookers
coolers93522493_c_oolers
coopers114019483_c_oopers
cooters94525723_c_ooters
corners94723313_c_orners
coroners104016223_coroners
crooner93714043_crooner_
crowners133710743_crowners
dehorners1344743dehorners
echoers12459693ech_o_ers
honers94324973__h_oners
hoofers134513323__hoofers
hookers144916513__hookers
hoopers123616483__hoopers
hooters104520473__hooters
hoovers134312703__hoovers
mooners94015343__mooners
ratooners965833ratooners
scanners10379703sc_anners
schemers1576703sch_emers
schillers14285663schillers
schmeers1574833sch_meers
schmoes14308543schmo_e_s
schmooses16275633schmoose_s
schmoozer25224363schmoozer_
schmoozes25214903schmooze_s
schnorrers1542573schnorrers
schnozes2244493schnoze_s
scholars1336683sch_olars
schooled1447043schoole_d
schools1249113schoo__ls
schussers1442553schussers
scoffers16286133sc_offers
scolders11288993sc_olders
scones84521303sc__one_s
scooper113812033sc_ooper_
scooter93312873sc_ooter_
scorers94115313sc__orers
scorner9259763sc_orner_
scoters93313813sc__oters
scourers10348533sc_ourers
scouters103411323sc_outers
scowders14276223sc_owders
scowlers13257353sc_owlers
screeners1136723screeners
scrooges1137163scrooge_s
scroungers1343183scroungers
scunners10357303sc_unners
seasoners946263seasoners
shiners104015943s_h_iners
shockers17319463s_hockers
shoers94518333s_h_o_ers
shooter103013993s_hooter_
shoppers153010763s_hoppers
shouters113510623s_houters
shovers134613003s_h_overs
showers134612683s_h_owers
shunners11317743s_hunners
snookers12398653s_nookers
snoopers10319843s_noopers
snoozers17296943s_noozers
sooner64220463s__ooner_
sorners73416873s__orners
spoofers13307323s_poofers
spoolers10349363s_poolers
spooneys13314583s_pooneys
stoners74817953s__toners
stookers12449793s_tookers
stoopers103711303s_toopers
suborners1146313suborners
summoners1344733summoners
swooner10358673s_wooner_
swoopers13317523s_woopers
whoopers16286263_whoopers

Search took 7 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641996.75022020.9
3Display Results99990.0333000.0
 (SQL Overall)178691996.95325699.8
 
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.