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

121 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
enthral10341093(None) 
enteral73516451enteral
enthrall11266831enthrall
enthrals11278901enthrals
inthral10249461inthral
antheral1149392antheral
anthrax1757152anthrax
antral65719412ant_ral
benthal1247962benth_al
central93114472cent_ral
dentural948082dentural
entera64216832entera_
enthralls12256132enthralls
entrap8710562ent_rap
estral64716512est_ral
inthrall11247062inthrall
inthrals11258502inthrals
ventral103612172vent_ral
anthill1048203anthill
antra56521923ant_ra_
anural65714743an_ural
apteral9311523apteral
astral66919283ast_ral
bathyal1544823bathyal
butyral1245713butyral
canthal12410053canth_al
cental84420963cent__al
centra84113883cent_ra_
centrals102712033cent_rals
centurial1147963centurial
citral81113893cit_ral
dental74319173dent__al
dentinal939503dentinal
dextral1577003dext_ral
disenthral1453073disenthral
ectypal1442773ectypal
enchorial1446683enchorial
encinal949253encinal
engrail846263en_grail
engram9310653en_gram
enhalo987573en_h_alo
enrol51014283en__rol
ensnarl784913ensnarl
entail61114343ent_ail
enter54726383enter__
enterable11312643enterable
enterally12410013enterally
entered82718883entered
enterer72015633enterer
enteric9314213enteric
enteron7313343enteron
enters64425643enter_s
enthalpy1642563enth_alpy
enthralled1443693enthralled
enthrone111110113enthrone
enthuse1046963enthuse
entia5318203ent_ia_
entire61617703entir_e
entirely1147333entirely
entires71517783entires
entoil6912493ent_oil
entozoal1744203entozoal
entrails8310163ent_rails
entrain7313073ent_rain
entrant7318873ent_rant
entraps9109763ent_raps
entreat7315263entreat
entree61817883ent_ree
entry82414263ent_r_y
enwheel1343403enwheel
enwrap1185213en_wrap
ephoral1248403ephoral
estival1036323estival
estray95713333est_ray
estrual7367933estrual
eternal72910893e_ternal
ethereal1146783e_thereal
ethical1238443e_thical
ethyl1136513e_th_yl
external1577223external
extra1239003ext_ra_
extras13310223ext_ras
futural1037283futural
general81010943gen_eral
gestural946033gestural
gnathal1144353gnath_al
integral946793integral
internal8414093internal
interval11710473interval
inthralls12216233inthralls
intimal9109943intimal
lateral7313573lateral
lethal939803leth_al
literal7613273literal
litoral7610763litoral
mensural1046233mensural
mental84521603ment__al
menthol1236733menth_ol
mitral81314323mit_ral
natural739513natural
neural6311993_neural
neutral737923neutral
pectoral121210503pectoral
peytral1287503peyt_ral
rental63922033rent__al
restoral8810983restoral
retral64419743ret_ral
sectoral10109543sectoral
sutural7310223sutural
tentorial9119603tentorial
textural1544943textural
thrall93810293__thrall
thraw1110515923__thraw
unmoral948693unmoral
unthread1244603unthread
urethral1154633urethral
ventrals112910003vent_rals
vestral104111013vest_ral
vestural1156473vestural
withal1238933with_al
zenithal2093343zenith_al

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.423422437.4
2DLD Change Limit1340271216.90619407.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.37524229.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.