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

118 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
telfering133625(None) 
peltering122011672peltering
pilfering1536392pilfering
teddering12256302teddering
teetering10239892teetering
telexing1646612tel_exing
telneting1035592telneting
telphering1644202telphering
tempering1438732tempering
tendering112210812tendering
tentering102313202tentering
tethering1339132tethering
tillering1037882tillering
weltering13219492weltering
altering91917113_altering
beavering1538703beavering
befleaing1544023befleaing
believing1535283believing
bettering122212753bettering
buffering1835223buffering
cellaring1238533cellaring
centering122915143centering
coffering1838043coffering
deafening1476273deafening
deferring1436143de_ferring
defleaing1444743defleaing
deleing93313953del_e_ing
deleting103314423del_eting
delivering1545173delivering
differing1746473differing
entering91920053_entering
faltering132211113faltering
festering132413173festering
fettering132310513fettering
fevering152510083fe_vering
filtering13199723filtering
fleering123811283_fleering
fullering1336653fullering
gendering12249753gendering
gettering112310033gettering
goffering1744483goffering
haltering132212003haltering
helmeting1545503helmeting
hollering1337743hollering
interfering1558923interfering
jeering153513043je__ering
lechering1538443lechering
leering83417643__leering
lettering102112073lettering
levering122212503le_vering
metering112915633me_tering
moldering1367863moldering
neutering1038963neutering
niffering1645133niffering
offering1536393_offering
paltering122612893paltering
peering103520353pe__ering
pelerine10313013pel_erine
pelleting1237953pelleting
peppering1337083peppering
pestering122315663pestering
petering112516813pe_tering
realtering1139473realtering
referring1338033re_ferring
refiring123513923re_firing
reflexing2035933reflexing
relieving1336693relieving
rendering112213183rendering
reoffering1744093reoffering
revering122918073re_vering
seafaring1345963seafaring
selfing112911623self__ing
severing122013853se_vering
sewering122411093se_wering
sheltering1446493sheltering
silvering1337923silvering
skeltering1545003skeltering
soldering1169033soldering
solferino1243873solferino
steamering1345443steamering
steering93916793ste__ering
suffering1637293suffering
sulfuring1345783sulfuring
sweltering1445233sweltering
tabering112211423t_abering
tampering1438453tampering
tapering112112503t_apering
tattering102212323tattering
tearing84021493te__aring
teaseling1036913teaseling
teazeling1934543teazeling
teeing73916973te__e_ing
teeming103513093te__eming
teleran7510183tel_eran_
telerans859473tel_erans
telfer9379893telfer___
telfered1234883telfer_ed
telfers10299073telfer__s
telling83321083tel__ling
telnetting1143883telnetting
tenuring938863te_nuring
tepefying1843233tepefying
texturing1735223texturing
tiering8315253t__iering
timbering14117723timbering
tinkering1437703tinkering
tittering102310313tittering
tochering1537153tochering
tottering10229613tottering
towering122610873t_owering
tuckering1635693tuckering
ulcering1139333_ulcering
veering113213683ve__ering
veluring1237563vel_uring
veneering1337663veneering
wafering15208893_wafering
westering132112643westering
wildering1456743wildering

Search took 8 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.410435831.7
2DLD Change Limit1486411186.81021826.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.26624592.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.