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

111 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
segetal86838(None) 
vegetal1156301vegetal
regental948942regental
segmental1265992segmental
septal84513382se_ptal
setal56430902s__etal
several1039532several
skeletal1244042skeletal
acetal84314903_acetal
argental947933argental
beget85632563beget__
begets96215523beget_s
bimetal1138433bimetal
cental84420963ce_ntal
cereal8315833cere_al
chaetal1238283chaetal
decretal1146353decretal
dental74319173de_ntal
digital937063digital
egal55119433_eg__al
egesta7428653_egesta_
federal1148533federal
festal94213563fe_stal
fetal85623373__fetal
foetal9311883_foetal
gametal1037603gametal
general81010933general
genital849793genital
geta56627443__geta_
getas65421483__getas
hematal1238953hematal
hyetal1236543_hyetal
legal65715943leg__al
meatal84114733me_atal
mental84521603me_ntal
metal75427383__metal
nepeta837893nepeta_
nepetas935943nepetas
pedestal1146403pedestal
pelletal1045733pelletal
peseta8310573peseta_
pesetas938753pesetas
petal76526893__petal
recital9412163recital
rectal84418133re_ctal
refutal1046943refutal
regal65023793reg__al
regear73512743rege_ar
reginal84814293reginal
regnal74812933reg_nal
renewal1038703renewal
rental63922023re_ntal
repeal84718283repe_al
reseal64819643rese_al
retotal739843retotal
reveal94115053reve_al
sagittal943283sagittal
scleral937863scleral
scrotal938493scrotal
seal45654373s__e_al
seconal9310073seconal
seel45042983se_e__l
seesaw935973se_esaw
seethe93712483se_ethe
seggar8357813seg_gar
seismal937303seismal
seitan62613233se_itan
semestral1185283semestral
semimetal1345753semimetal
seminal91213403seminal
sendal73314993se_ndal
seneca839793seneca_
senecas939013senecas
senega738173senega_
senegas837253senegas
sensual738053sensual
sepal77723003s__epal
septa75518083se_pta_
seral56336383s__eral
serial64625863se_rial
serosal7311153serosal
serumal938783serumal
serval93913413se_rval
seta45637313s__eta_
setae56026223s__etae
severals1137593severals
sextan13389643se_xtan
sexual1338413se_xual
sheal84927703s_he_al
shegetz2044273sheget_z
shtetel1033943shtetel
shtetl936443shtet_l
signal73711483sig_nal
societal1045723societal
somital939403somital
spheral1238423spheral
spital83813873s_pital
squeal1538023sque_al
statal61613223s_tatal
steal56125473s_te_al
stratal72710603stratal
tapetal938273tapetal
tectal83713253te_ctal
tegmental1275393tegmental
vegetable1545683vegetable
vegetably1843953vegetably
vegetally1644213vegetally
vegetant1246963vegetant
vegetate1246673vegetate
vegete1039483veget_e
vestal94615573ve_stal

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 Limit1340271116.73319906.0
3Display Results1111110.0333363.6
 (SQL Overall)1786911117.17224915.1
 
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.