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

107 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
telerans85947(None) 
teleran7510181teleran_
relearns836302relearns
telegas837442telega_s
telegrams1244982telegrams
teleman959572teleman_
tolerant8411462tolerant
veterans1148852veterans
ailerons849853ailerons
beleaps1138053bele_aps
bemeans1148743beme_ans
caterans10313223caterans
celebrant1347013celebrant
celebrants1444163celebrants
celeriacs1344113celeriacs
celeries10316313celeries
cleans85817053_cle_ans
decerns10119053decer_ns
deewans11306903de_ewans
deleads9379703dele_ads
demeans1039723deme_ans
dextrans1695983dextrans
eelgrass942973eelgrass
elans55527753_el__ans
elegant8311503_elegant
elevens1066803_elevens
elevons1067573_elevons
federals1247303federals
generals9109333generals
gleans75014743_gle_ans
leans55536253__le_ans
learns65513743__learns
lemans85316393__lemans
lorans65117603__lorans
melenas999203melena_s
monerans10310343monerans
pelerine10313013pelerine
pelerines11311843pelerines
pelicans1238093pelicans
recleans1037513recle_ans
reearns749103re_earns
relearn747973relearn_
relearnt849213relearnt
relevant1149243relevant
reloans7313133rel_oans
scleras948223sclera_s
secerns987733secer_ns
severals1137593severals
talers64628143taler__s
tarletans944653tarletans
tavernas11365043tavernas
taverns10317803taver_ns
teens56227483te_e__ns
telecast1048303telecast
telecasts1145543telecasts
telecoms1246473telecoms
teledus835093tele_dus
telefax1743203telefa_x
telefaxes1943813telefaxes
telega736773telega__
telegony1244223telegony
telegram1146003telegra_m
telegraph1545143telegraph
telegraphs1645193telegraphs
telemark1444123telemark
telemarks1543663telemarks
telemen9310173telemen_
teleosts846423teleosts
telepath1345143telepath
telepaths1444413telepaths
teleplays1442713teleplays
teles54536003tele___s
teleses7313123tele_ses
telesis7310793tele_sis
telethons1246023telethons
telexes1438353tele_xes
telexing1646613telexing
telfering1336253telfering
telfers10299073telfer__s
tellers73717603teller__s
tellurians10103563tellurians
telsons739223tel_sons
temperas12278233tempera_s
teopans939203te_opans
tephras1236283tephra_s
terais64023513t__erais
terns55226873t__er_ns
terrains8410323te_rrains
terrane72814233te_rrane
terranes82514433te_rranes
terras63516973te_rra_s
terreens8246533terreens
tertians839103tertians
tetrads82910193te_trads
tetras63017623te_tra_s
therians1138313t_herians
tilers63523503tiler__s
tolans64319273tol__ans
tolerance1145983tolerance
tolerances1245993tolerances
tolerate8312323tolerate
tolerates9312123tolerates
trans54933043t___rans
trepans92311593t_repans
unlearns844453unlearns
valerians1245343valerians
veteran1039353veteran_

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621078.03018202.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.49921024.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.