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

62 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
airwaves144472(None) 
airwave1344431airwave_
airdates939712airdates
airfares1146692airfares
airways1336242airwa_ys
abrades10312073abr_ades
acreages1138363acreages
aerates74627483aer_ates
agaves104611513a__gaves
agrafes1137523agr_afes
airbags1036293airba_gs
airbuses1067073airbuses
airdate8311323airdate_
airfare1047243airfare_
airframes1443663airframes
airholes1138033airholes
airlines8312793airlines
airmails1045263airmails
airparks1443913airparks
airplanes1187233airplanes
airscapes1345023airscapes
airspaces1344503airspaces
airtimes1037503airtimes
airward1148133airwa_rd
airway1237693airwa__y
airwise1036713airwise_
airwomen1344823airwomen
alewives1444283alewives
amirates101114793amir_ates
arames84622573a_r_ames
arcades101113193a_rcades
arrases71214543a_rrases
arrives101311513a_rrives
asswages1255053asswages
awakes135012473a__wakes
barwares13610093barwares
bereaves1338263bereaves
braves115524083_br_aves
craves115825393_cr_aves
dissaves1239413dissaves
distaves12311393distaves
earwaxes1844703earwaxes
fairways1743873fairwa_ys
firmwares1743853firmwares
graves104624003_gr_aves
greaves113311443_greaves
inweaves1445043_inweaves
irades74517393_ir_ades
microwaves2045363microwaves
midwives17274803midwives
mirages102213533mir_ages
picowaves19102893picowaves
pinwales1367963pinwales
pirates93020323pir_ates
raves85441973__r_aves
reaves94127573__reaves
thraves13469713thr_aves
tinwares1137903tinwares
tirades8311723tir_ades
traves94222743_tr_aves
virgates1237903virgates
waves115633923___waves

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.1561145455.1
2DLD Change Limit146162628.45317291.1
3Display Results62620.0163875.0
 (SQL Overall)178691628.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.