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

82 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
sorcerers114532(None) 
sorcerer1036431sorcerer_
sorceress1144011sorceress
borderers1276332borderers
orderers9116562_orderers
solderers1066532solderers
sorceries1149932sorceries
sorcerous1145912sorcerous
barterers11269633barterers
borderer1168103borderer_
careerers1137243careerers
coherers132310733co_herers
conceders1437953conceders
coverers132712123co_verers
dodderers1243803dodderers
forbearers1543673forbearers
forceless1435723forceless
forcers124215713forc__ers
forevers1438173for_evers
fosterers12238023fosterers
hoverers14289023ho_verers
larceners1135993larceners
loiterers936263loiterers
murderers1244593murderers
offerers1434933_offerers
orderer8127943_orderer_
parceners1337453parceners
ponderers12248453ponderers
porteress1137933porteress
potterers11218663potterers
powderers15214793powderers
procurers1345033procurers
sarcenets1146953sarcenets
scarers94618503s__carers
scorchers16145513scorc_hers
scorers94115313s__corers
screeners1136723screeners
screwers13358053scr_ewers
seceders11277963s_eceders
securers1057153s_ecurers
shiverers15155773shiverers
shorteners1345083shorteners
showerers1545073showerers
shriekers16224423shriekers
silverers12215753silverers
simperers1335933simperers
sincerer1037203sincerer_
slaverers12165993slaverers
sliverers12196363sliverers
slobberers14152883slobberers
smotherers1543813smotherers
sneerers8309803s_neerers
snickerers16133583snickerers
snorkelers1442273snorkelers
soarers74118093so__arers
soberer93110353so_berer_
socagers1196363so_cagers
soccers1138393so_c_cers
softeners1245133softeners
solderer947183solderer_
solerets839693so_lerets
sollerets945263sollerets
sorceresses1343373sorceresses
sorcery1237033sorc__ery
soreness8914793sor_eness
sorners73416873sor__ners
sorrels7310723sor__rels
sorrowers1274753sorrowers
sorters74221133sor__ters
sourceless1273013sourceless
steerers82511353s_teerers
streekers13195793streekers
strewers11409053str_ewers
succorers13124203succorers
sufferers1555103sufferers
sunderers1039073sunderers
torcheres1446863torchere_s
torchiers1445073torchiers
torturers944343torturers
totterers9186813totterers
verderers1344843verderers
wonderers13217933wonderers

Search took 10 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.1561145455.1
2DLD Change Limit148641828.82616841.3
3Display Results82820.0332484.8
 (SQL Overall)178691829.01519821.5
 
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.