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

112 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
telneting103559(None) 
telnetting1143881telnetting
deleting103314422del_eting
helmeting1545502helmeting
pelleting1237952pelleting
relenting102716772relenting
telexing1646612tel_exing
telfering1336252telfering
tenting84621152te_n_ting
believing1535283believing
belting104119133bel__ting
billeting1236633billeting
bonneting1236173bonneting
bulleting1236643bulleting
cementing1438763cementing
colleting12311053colleting
delating103119603del_ating
deleing93313953del_e_ing
delineating1346373delineating
delisting112710503delisting
dementing13311043dementing
denoting10311753de_noting
denting94422183de_n_ting
depleting1378193depleting
elating83423083_el_ating
electing112113783_electing
eluting84115293_el_uting
feinting123410833fein_ting
fellating1339243fellating
felting113515213fel__ting
ferreting13127693ferreting
fileting1239303fil_eting
filleting1335843filleting
fleeting122910323_fleeting
galleting1137623galleting
gelating103015733gel_ating
gleeting10279173_gleeting
henting113719653he_n_ting
kenneling1464083kenneling
kerneling1464403kerneling
keynoting1742813keynoting
leniting9312353le_niting
meeting103314963me__eting
melting103317753mel__ting
palleting1238733palleting
peltering122011673peltering
pelting102917273pel__ting
relating92725443rel_ating
relending112412023relending
reletting102713943reletting
relieving1336693relieving
relisting102414353relisting
relucting1239773relucting
remeeting12311433remeeting
reneging102111533re_neging
renesting102514703re_nesting
renewing121910713re_newing
renting84026853re_n_ting
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
reuniting10310693reuniting
secreting1279823secreting
selecting12310533selecting
signeting1136223signeting
sklenting1475123sklenting
sleeting93114163_sleeting
sonneting1037003sonneting
tableting1236343tableting
tainting93613583tain_ting
targeting1137303targeting
taunting93510933taun_ting
teaseling1036913teaseling
teazeling1934543teazeling
teddering12256303teddering
teeing73916973te__e_ing
teeming103513093te__eming
teetering10239893teetering
teething1237163te__ething
teletyping1642473tel_etyping
telling83321083tel__ling
telnet6518833telnet___
telneted935073telnet_ed
telnets738373telnet__s
telnetted1043813telnetted
telphering1644203telphering
tempering1438733tempering
tempesting1544443tempesting
tempting1357343te_mpting
tenanting1036213tenanting
tendering112210813tendering
tending94419163te_n_ding
tenoning938893te_noning
tensing84616653te_n_sing
tentering102313203tentering
tenuring938863te_nuring
testing86021053te__sting
tethering1339133tethering
ticketing1635633ticketing
tillering1037883tillering
tilting83417103til__ting
tincting1148883t_incting
tinting84620603t_in_ting
toileting1036263toileting
trinketing1544153trinketing
tunneling1034693tunneling
tweeting12267033t_weeting
valeting1238843val_eting
venting114218093ve_n_ting
weeting113816053we__eting
weltering13219493weltering
welting113615313wel__ting

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.1531167915.0
2DLD Change Limit1486411127.69019329.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.88922650.7
 
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.