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

74 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
airfares114669(None) 
airfare1047241airfare_
airdates939712airdates
airframes1443662airframes
airparks1443912airparks
airwaves1444722airwaves
carfares13310322carfares
infares10313022_infares
warfares1436682warfares
abrades10312073abr_ades
acreages1138363acreages
aerates74627483aer_ates
afars85716513a__far_s
affaires1444303a_ffaires
agrafes1137523agr_afes
agraffes1553043agraffes
airbags1036293airba_gs
airbuses1067073airbuses
aircrew12113913air_crew
aircrews13122813air_crews
airdate8311323airdate_
airers64922313air_er_s
airflows1443833airflows
airfoils1144003airfoils
airframe1344293airframe
airholes1138033airholes
airlines8312793airlines
airmails1045263airmails
airpark1344923airpar_k
airplanes1187233airplanes
airports1046463airports
airscapes1345023airscapes
airscrew13102933airscrew
airscrews1492323airscrews
airspaces1344503airspaces
airtimes1037503airtimes
airward1148133airwar_d
airwave1344433airwave_
airways1336243airwa_ys
amirates101114793amir_ates
arames84622573a_r_ames
arbores94016033a_rbores
arcades101113193a_rcades
armures9510273a_rmures
arrases71214543a_rrases
arrears738843arrear_s
barwares13610093barwares
bifaces1448063bi_faces
birdfarms1741853birdfarms
carfare12310073carfare_
curares94916853cur_ares
fanfares1436773fanfares
fares85852873___fares
firearms1335403firearms
firmwares1743853firmwares
furfures1445663furfures
giraffes1542603giraffes
infare9313083_infare_
irades74517393_ir_ades
mirages102213533mir_ages
misfires132210583misfires
pirates93020323pir_ates
rares55247443__r_ares
rimfires1344203rimfires
serfages1238233serfages
sirdars8228213sirdar_s
surfaces1338673surfaces
tinwares1137903tinwares
tirades8311723tir_ades
urares64519093_ur_ares
virgates1237903virgates
warfare1336733warfare_
welfares1445543welfares
workfares1943393workfares

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.1561145455.1
2DLD Change Limit146162747.79618748.3
3Display Results74740.0332242.4
 (SQL Overall)178691747.98522378.3
 
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.