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

80 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
airmail94621(None) 
airmails1045271airmails
airfoil1044462airfoil
airmailed1242902airmailed
airman82414222airma_n
abigail1044193abigail
acromial1248463acromial
aerial64625713aeria_l
afraid1049723afr_aid
agnail739533a_gnail
aidman92410623aidma_n
aimful1166703ai_mful
airbag956963airba_g
airbags1036293airbags
airdate8311323airdate
airfare1047243airfare
airfoils1144003airfoils
airily93014823air__ily
airmailing1343633airmailing
airmen82612353airm_en
airmobile1342283airmobile
airpark1344923airpark
airship1248523airship
airward1148133airward
airwave1344433airwave
airway1237693airwa_y
airways1336243airways
amain74922913a__main
animal85016253anima_l
aortal65217513aorta_l
aramid93315613a_ramid
archil11611573a_rchil
areal55928733a_rea_l
argal65023393a_rga_l
argali75013753a_rgali
argil65116883a_r_gil
aril45843023a_r__il
armada938783a_rmada
armful1167163a_rmful
armpit10811093a_rmpit
artal55525473a_rta_l
arval86017013a_rva_l
assail6610153a_ssail
atrial65418943atria_l
aural54428963aur_a_l
avail8313883a__vail
barmaid1238203barmaid
brail75525553_br_ail
camail10314833_camail
curtail9299663curtail
dairymaid1651803dairymaid
derail74218813der_ail
dermal93614343derma_l
dismal92412243disma_l
drail65020973_dr_ail
email74715103__email
firman112211343firma_n
firmans12238523firmans
formal113215203forma_l
frail85220213_fr_ail
gimmal11247513gimma_l
grail64622873_gr_ail
hairball1344633hairball
hermai118912863hermai_
hiemal11339503hiema_l
mail65543453___mail
mainsail1045173mainsail
mermaid1297853mermaid
normal83213533norma_l
pigtail1046623pigtail
pintail9311183pintail
primal104014623prima_l
rail46147763__r_ail
remail85017123_remail
serail64222673ser_ail
trail55126773_tr_ail
turmoil944723turmoil
vermeil1285223vermeil
viral86419593vir_a_l
wormil1138043worm_il

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 Limit134027806.78319759.3
3Display Results80800.0302666.7
 (SQL Overall)178691807.21924752.9
 
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.