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

73 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
airwave134443(None) 
airwaves1444721airwaves
airdate8311322airdate
airfare1047242airfare
airward1148132airward
airway1237692airwa_y
airways1336242airways
airwise1036712airwise
abrade9313053abr_ade
acreage1037843acreage
aerate64830553aer_ate
agave95314033a__gave
agrafe1038093agr_afe
airbag956963airba_g
airbags1036293airbags
airdates939733airdates
airfares1146693airfares
airframe1344293airframe
airhole1048273airhole
airlike11310333airlike
airline7315043airline
airmail946213airmail
airman82414233airma_n
airpark1344923airpark
airplane1067793airplane
airscape1245363airscape
airspace1244653airspace
airtime948063airtime
airwomen1344823airwomen
amirate91115953amir_ate
aortae65115473aorta_e
arame75026633a_r_ame
arcade91013643a_rcade
arcane81216743a_rcane
areae55229753a_rea_e
arrive91311793a_rrive
asswage1144673asswage
aurae54128113aur_a_e
aurate64426473aur_ate
aureate72515293aureate
awake125014783a__wake
aware86420023a__ware
barware12610703barware
bereave1258353bereave
brave104925503_br_ave
cirrate92413493cirrate
crave105626313_cr_ave
dissave1139413dissave
drave95219273_dr_ave
fairway1644333fairwa_y
fairways1743873fairways
firmware1643963firmware
forgave1435853forgave
grave94624873_gr_ave
greave104611493_greave
inweave1344723_inweave
inwove12167273_inwove
irade65618153_ir_ade
irate55627983_ir_ate
microwave1945033microwave
mirage92313653mir_age
misgave13298283misgave
picowave18102793picowave
pinwale1257843pinwale
pirate82322883pir_ate
rave75542093__r_ave
reave84528023__reave
thrave126010273thr_ave
tinware1038603tinware
tirade7311693tir_ade
trave85223033_tr_ave
virgate1138733virgate
wave105234733___wave

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.420425454.8
2DLD Change Limit134027737.03019065.0
3Display Results73730.0164562.5
 (SQL Overall)178691737.46623934.0
 
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.