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

86 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
enthrals1127890(None) 
enthral103410931enthral_
enthrall11266831enthrall
enthralls12256131enthralls
inthrals11258501inthrals
centrals102712032cent_rals
enteral73516452enteral_
entrails8310162ent_rails
entraps9109762ent_raps
inthral10249462inthral_
inthrall11247062inthrall
inthralls12216232inthralls
ventrals112910002vent_rals
antheral1149393antheral_
anthills1146533anthills
anthraces1448893anthraces
anthrax1757153anthra_x
antral65719413ant_ral_
astrals75515243ast_rals
bentgrass1242963bentgrass
benthal1247963benth_al_
butyrals1344503butyrals
centals94317053cent__als
central93114473cent_ral_
citrals91111673cit_rals
dentals83915393dent__als
dentural948083dentural_
disenthrals1552643disenthrals
engrails945383en_grails
engrams1038073en_grams
enhalo987573en_h_alo
enhalos1087533en_h_alos
enrols61213383en__rols
ensnarls873393ensnarls
entails7912823ent_ails
entera64216833entera__
enterable11312643enterable
enterally12410013enterally
enterers82214153enterers
enterics10312863enterics
enterons8314153enterons
enters64425643enter__s
enthalpy1642563enth_alpy
enthralled1443693enthralled
enthrone111110113enthrone
enthrones12910073enthrones
enthuses1138253enthuses
entirely1147333entirely
entires71517783entir_es
entoils7810733ent_oils
entrain7313073ent_rain
entrains8312963ent_rains
entrant7318873ent_rant
entrants8311753ent_rants
entrap8710563ent_ra_p
entreats839773entreats
entrees71813773ent_rees
entries71523163ent_ries
enwheels1442853enwheels
enwraps1284833en_wraps
estral64716513est_ral_
estrays10529403est_rays
eternals8238953e_ternals
ethicals1345533e_thicals
ethyls1235903e_th_yls
externals1666623externals
extras13310223ext_ra_s
generals9109343gen_erals
integrals1046473integrals
internals9712733internals
intervals12810153intervals
laterals8312753laterals
lethals1038113leth_als
literals8312293literals
menthols1347043menth_ols
naturals847903naturals
neutrals846283neutrals
pectorals13128153pectorals
peytrals1355493peyt_rals
rentals74017483rent__als
restorals978073restorals
thrall93810293__thrall
thralls10299043__thralls
thraws129211103__thraws
unthreads1343633unthreads
ventral103612173vent_ral_

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.626285448.9
2DLD Change Limit146162868.03018202.0
3Display Results86860.0332606.1
 (SQL Overall)178691868.68920565.2
 
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.