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

111 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
wonderers1321793(None) 
ponderers12248451ponderers
wanderers13228481wanderers
wonderer12249181wonderer_
borderers1276332borderers
dodderers1243802dodderers
hinderers1337352hinderers
orderers9116562_orderers
panderers12229152panderers
ponderer112410192ponderer_
powderers15214792powderers
renderers10208092renderers
solderers1066532solderers
sunderers1039072sunderers
tenderers10227802tenderers
wanderer122210122wanderer_
winterers12209722winterers
wondered13239942wondere_d
wonders113315992wond__ers
banterers112410003banterers
blunderers1343943blunderers
bonders104120663bond__ers
borderer1168103borderer_
boulderers1343663boulderers
broiderers1343223broiderers
coherers132310733co_herers
conceders1437953conceders
condemners1546023condemners
condensers1386373condensers
condolers122710573condolers
condoners122811513condoners
condores113315643condore_s
conducers14136563conducers
conferees14610623conferees
conferrers1546453conferrers
congeners122511133congeners
conjurers18126233conjurers
conquerers2144223conquerers
conservers1547683conservers
conveners142911443conveners
conversers1547353conversers
converters1539633converters
conveyers17267203conveyers
coverers132712123co_verers
dodderer1144203dodderer_
endurers9317953_endurers
enterers82214153_enterers
fingerers13136303fingerers
fondlers12338023fond_lers
fosterers12238023fosterers
hankerers16226713hankerers
hinderer1238273hinderer_
honorers1139263hon_orers
honourers1245573honourers
hoverers14289023ho_verers
indexers16326373_indexers
launderers1183873launderers
lingerers10126923lingerers
loiterers936263loiterers
maunderers1383753maunderers
meanderers1343803meanderers
modelers1138463mo_delers
moneyers1337423mon_eyers
murderers1244593murderers
nondesert1048193nondesert
offerers1434933_offerers
orderer8127943_orderer_
panderer112210913panderer_
plunderers1343333plunderers
pondered126411293pondere_d
ponderous1267273ponderous
ponders103618843pond__ers
potterers11218663potterers
powderer14245593powderer_
renderer9239743renderer_
rondelets1045263rondelets
rondures937713rondure_s
slanderers1145143slanderers
sneerers8309803_sneerers
solderer947183solderer_
sonders83820713sond__ers
sorcerers1145323sorcerers
sunderer9310523sunderer_
tenderer9228733tenderer_
thunderers1443973thunderers
tinkerers1395423tinkerers
totterers9186813totterers
veneerers1244523veneerers
verderers1344843verderers
wagerers12247613w_agerers
wandered132110793wandere_d
wanderoos1345553wanderoos
wanders114221333wand__ers
waterers112312783w_aterers
waverers14318613w_averers
wideners12257993w_ideners
winders113721263wind__ers
winterer112110443winterer_
witherers15146843witherers
wonder103617813wond__er_
wonderful1642643wonderful
wondering142110463wondering
wonderment1646003wonderment
wonderments1754513wonderments
wonderwork2152333wonderwork
wonderworks2252023wonderworks
wondrous1246823wond_rous
wonners104312813won__ners
woodborers1652493woodborers
woodener1245763woodener_
yodelers1235673yo_delers

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.406440125.6
2DLD Change Limit1486411116.47022973.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.92225814.9
 
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.