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 “email” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
email7471510(None) 
emails84412341emails
mail65543451_mail
remail85017121remail
ail37171042__ail
amain74922912amain
avail8313882avail
bail65042802_bail
bewail1189582bewail
brail75525552brail
camail10314832camail
derail74218812derail
detail74516432detail
drail65020972drail
earl45838142e_arl
egal55119432ega_l
elain55324702elain
emailed10359212emailed
emic86422752em_ic
emir65918702em_ir
emit65438422em_it
entail61114342entail
ervil8310302ervil
evil75318072e_vil
fail74840242_fail
flail85316182flail
frail85220212frail
grail64622872grail
hail74839062_hail
hemal104419802hema_l
jail115529092_jail
jezail2234642jezail
kail85131492_kail
maid75537662_maid
maile75232222_maile
maill74420792_maill
mails76037782_mails
maim85831492_maim
main65345522_main
mair66133782_mair
mall64639372_mall
marl66341622_marl
maul64830722_maul
meal65643172mea_l
mil55752112_m_il
moil65534092_moil
nail45838652_nail
pail66141832_pail
quail144314362quail
rail46147762_rail
remails94714562remails
remain85919862remain
renail65020762renail
resail64418732resail
retail65522072retail
sail45447162_sail
serail64222672serail
small74016262small
snail57020202snail
spail74921552spail
swail86217162swail
tail45443652_tail
tenail64516112tenail
trail55126772trail
vail75432552_vail
wail75238822_wail

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800661.40638264.6
3Display Results66660.0164125.0
 (SQL Overall)178691661.718104011.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.