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

97 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
teredines104945(None) 
pteridines1345462pteridines
terebenes1146062terebenes
terrines82117552ter_rines
acridines1247723acridines
aerodynes1344603aerodynes
beedies10314203be_edi_es
beelines103312803be_elines
berberines1445633berberines
berlines102315453ber_lines
breedings13375763breedings
emetines10611053_emetines
eremites10312603_eremites
ermines9416673_er_mines
errhines1136413_errhines
eserines8413743_eserines
gradines103615253_gradines
greediness1245833greediness
heredes11313133hered__es
heredities1447223heredities
heresies11312693heresi_es
heroines112916573her_oines
kerosines1357103kerosines
neediness10227733ne_ediness
nerdiness10208333ner_diness
nereides938503nere_ides
nervines112310463ner_vines
ordines83014903_or_dines
pelerines11311843pelerines
peregrines1346513peregrines
pteridine1246743pteridine_
pyridines1546473pyridines
redefines1347413redefines
redlines93916083__redlines
reediness10239613re_ediness
reedings103510363re_edings
refines105426343__refines
relines75331323__relines
remedies11310553remedi_es
repines94927383__repines
rereadings12124543rereadings
reredoses1045773reredoses
rereminds1244363rereminds
retines75134673__retines
rexines144719153__rexines
sardines92815563sar_dines
seediness10219173se_ediness
sereins73716123sere_in_s
serenes73222903sere__nes
serines74229543ser__ines
serotines9312073serotines
sordines92414073sor_dines
tapelines1138463tapelines
tardies84225863tar_di_es
tardiness10229913tar_diness
teddies92711283te_ddi_es
televises1246353televises
tepefies1346893tepefi_es
terebene1045363terebene_
terebinth1443413terebinth
terebinths1551913terebinths
teredos839183tered__os
tergites9310543ter_gites
terminus1037393ter_minus
termites10313693ter_mites
termtimes1354803termtimes
ternes65422903ter___nes
terpenes102111573ter_penes
terrains8410323terrain_s
terranes82514433ter_ranes
terrenes82212603ter_renes
terries73425633ter_ri_es
terrine72517573ter_rine_
terylenes1244933terylenes
testudines1143093testudines
theines104013233t_he_ines
theremins14106053theremin_s
threadiness1543463threadiness
threonines1344553threonines
timelines1148443timelines
tiredness1036933tired_ness
tolidines1046883tolidines
treddles1036263t_reddles
trendies9312213trendi_es
trendiness1146223trendiness
trephines1448483trephines
trines64132563t_r__ines
tropines102214923t_ropines
turbines1039903tur_bines
turdine8310283tur_dine_
tweediness1443173tweediness
tyramines1447213tyramines
tyrosines1246863tyrosines
uridines989513_uridines
verdins112812333ver_din_s
versines112213823ver_sines
weediness13247043we_ediness

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.423422437.4
2DLD Change Limit148641977.42020032.5
3Display Results97970.0332939.4
 (SQL Overall)178691977.87622688.0
 
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.