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

119 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
benthic143747(None) 
benefic1446042benefic
benthal1247952benthal
benthon1237692benthon
benthonic1644592benthonic
benthos1238372benthos
benzoic2045032benzoic
centric11312402centric
ethic101511222_e_thic
lentic83515742lent_ic
xanthic1945862xanthic
acentric1247533acentric
antic75728863_ant_ic
bacchic1545813bacchic
banshie12129543banshie
beatific1544223beatific
beatnik1344863beatnik
bedtick1645233bedt_ick
bench125619503bench__
benched154713943benched
bencher144113483bencher
benches143918603benches
benching163411343benching
benedick1743093benedick
benedict1346423benedict
benefice1545003benefice
benefit1248073benefit
benni74715363ben_ni_
bennis84314803ben_nis
bent67759913bent___
benthons1337973benthons
bento75922953bent__o
bentos86218303bent_os
bents76033693bent__s
benzin1738933ben_zin
benzoin1846263benzoin
benzylic2442283benzylic
berth104917883berth__
bertha11429173berth_a
berthas12398763berthas
berthed13259123berthed
berthing14209603berthing
berths114712423berth_s
bestir8311163best_ir
bestrid1039973bestrid
beth96629233be_th__
bethel1169643be_thel
bethink1677203be_think
beths105519223be_th_s
beylic1337823be_ylic
bicentric1544283bicentric
bioethic1544693bioethic
biontic1148333biont_ic
biotic103816613biot_ic
bustic101012693bust_ic
canthi11310973canthi_
cantic103920543cant_ic
centai84814783centai_
delphic1545103delphic
deltaic1037023deltaic
deltic9312503delt_ic
dentil74017883dent_il
dentin73919573dent_in
dentoid9310663dentoid
deontic1038883deont_ic
elenchic1544233elenchic
enatic8317563_enatic
enolic8413353_enolic
entail61114343_entail
enteric9314213_enteric
enthetic131110613_enthetic
entia5318203_ent_ia
entice81316863_ent_ice
entoil6912493_entoil
entopic1149953_entopic
erethic1257723erethic
ethics11169283_e_thics
ethnic1148853_e_thnic
etic66123953_e_t_ic
fenthion1444613fenthion
generic101310753generic
genetic101211783genetic
genic85119393gen__ic
genomic1237923genomic
gentil74115123gent_il
gentrice1148813gentrice
gestic9312773gest_ic
gnathic1344843gnathic
gothic1237793_gothic
hectic132311523hect_ic
identic1038043ident_ic
kenotic1359713kenotic
lentil64315393lent_il
lentoid8310683lentoid
lithic1139493_lithic
mantic104120903mant_ic
mantric11311353mantric
menhir1136783men_hir
menthol1236733menthol
metric10314683me_tric
mythic1637273_mythic
ontic74418573_ont_ic
ornithic1343623ornithic
pectic122913873pect_ic
pentomic1448143pentomic
peptic122113153pept_ic
senti56226703sent_i_
septic102713193sept_ic
spathic1437543spathic
tantric939593tantric
tenth85421833tenth__
tenthly1335743tenthly
tenths94412663tenth_s
tentie62521183tent_ie
unchic1338643_unchic
venatic12311523venatic
ventail10310453ventail
xanthin1747043xanthin
xenic144114643xen__ic

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271196.59320328.7
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.04525364.2
 
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.