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

88 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
recounters124621(None) 
recounter1137941recounter_
rencounters1343301rencounters
counters103320192__counters
encounters1244552encounters
rebounders1343932rebounders
recanters112310482rec_anters
reconfers1437212reco_nfers
recountals1243282recountals
recounted1238722recounte_d
recounts1038772recount__s
recruiters1243712recruiters
reencounters1451722reencounters
rencounter1244292rencounter_
renouncers1244622renouncers
accouters1344873accou_ters
chunters133910903__chunters
cointers103616423__cointers
coulters103614313__coulters
counter94220153__counter_
countess103710053__countess
courters103015373__courters
couters93827303__cou_ters
decanters12229223dec_anters
decenters122410373dec_enters
decouplers1573083decouplers
denouncers1343403denouncers
discounters1445763discounters
encounter1145183encounter_
mounters103712503__mounters
raconteurs1241853raco_nteurs
rebounder1245103rebounder_
rebutters1195093re_butters
recanter101913153rec_anter_
recenter102715443rec_enter_
recharters1555423recharters
reciters102613113rec__iters
reckoners1545113reckon_ers
recliners11279113reclin_ers
recognizers2353213recognizers
recoilers11318153reco_ilers
reconfer1337673reco_nfer_
reconnoiters1462033reconnoiters
reconquers2193353reconquers
recontours1243463reco_ntours
reconvert1449473reco_nvert
reconverts1545723reco_nverts
reconveys1743533reco_nveys
recorders12187953reco_rders
recount9315173recount___
recountal1144193recount_al
recounting1339193recounting
recouples13116823recouple_s
recourses1137733recourse_s
recoverers15133613recoverers
recovers133511123reco__vers
recruiter1144873recruiter_
redoublers1342413redoublers
reencounter1352203reencounter_
reenters82915313re__enters
refunders1334973re_funders
refuters11449613re_fu_ters
reinters82614773re__inters
rejoinders1843123rejoinders
relaunders1153103relaunders
remounted1236283remounte_d
remounts1036373remount__s
rencontres1244383renco_ntres
rencountered1552213rencountered
renouncer1145843renouncer_
renounces1147543renounce_s
renters74224823re___nters
repenters112511553re_penters
reporters1139173repo_rters
reprinters1295793reprinters
requiters18176553re_quiters
reroutes8312223rerou_te_s
resorters939693reso_rters
retorters938773reto_rters
retouchers1543483retouchers
reuniters936423re__uniters
reutters8138573re__utters
revolters12297483revo_lters
rounders92613703r__ounders
rousters84315683r__ousters
routers74822873r__ou_ters
scouters103411323_scou_ters
seconders1236953seco_nders

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 Filter1786911406030.406440125.6
2DLD Change Limit140603886.47021731.5
3Display Results88880.0461913.0
 (SQL Overall)178691886.92225814.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.