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

90 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
engrails94538(None) 
engrail846261engrail_
engrains937581engrains
entrails8310161entrails
engrafts1294702engrafts
engrailed1144322engrailed
engrain838352engrai_n
engrams1038072engra_ms
engraves1237232engraves
entails7912822en_tails
entrains8312962entrains
grails77518782__grails
ingrains948982ingrains
agnails837003_agnails
angarias9310553angarias
angaries9314393angaries
angrily1137723angr_ily
bangtails1243593bangtails
bedrails1136293bedrails
brails84621293__brails
centrals102712033centra_ls
contrails11410543contrails
derails84216393_derails
drails74716953__drails
emails84412343e__mails
embroils1245773embroils
enchains1348523enchains
endbrains1244063endbrains
endrins8312163endr_ins
energids1045583energids
energies9310783energies
enframes1357453enframes
engages92912493eng_ages
engild8107613eng__ild
engilds974863eng__ilds
engraft11118623engra_ft
engrailing1244853engrailing
engrained1145493engrained
engram9310653engra__m
engramme1344053engramme
engrammes1444513engrammes
engrave1137133engra_ve
engraved1335813engraved
engraver1245333engraver
engravers1344313engravers
engraving1446013engraving
engravings1542503engravings
engross837123engr_oss
enrages83114853en_rages
enrolls7108093en_rolls
enrols61213383en_r_ols
ensnarls873393ensnarls
entail61114343en_tail_
enthralls12256133enthralls
enthrals11278903enthra_ls
entoils7810733en_toils
entrain7313073entrai_n
entrants8311753entrants
entraps9109763entra_ps
entries71523163entr_ies
enwraps1284833enwra_ps
ervils948773e__rvils
frails93716473__frails
generals9109333genera_ls
graals74112913__graals
grail64622873__grail_
grains74223093__grains
handrails1346513handrails
hangnails1353003hangnails
ingrafts12105803ingrafts
ingrain839523ingrai_n
ingrates9514173ingrates
lugsails942743lugsails
monorails1148743monorails
nails55730403_n__ails
negroids10116323negroids
pigtails1146033pigtails
rails55937403___rails
renails74917263ren__ails
ringtails1044443ringtails
serails73318363_serails
snails64816653sn__ails
tenails73713923ten__ails
tendrils946443tendr_ils
trails64622513__trails
unbraids1144963unbraids
unnails738223un_nails
ventails1139823ven_tails
ventrals112910003ventra_ls
wagtails1244443wagtails

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 Filter1786911461620.423422437.4
2DLD Change Limit146162907.14020470.9
3Display Results90900.0461956.5
 (SQL Overall)178691907.60923484.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.