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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
airwise103671(None) 
airlike11310332airlike
airline7315032airline
airtime948062airtime
airwave1344432airwave
anywise1345202anywise
arise56436432a_r_ise
abris75722603abr_is_
abscise1145953abscise
advise10139223a_dvise
aerie54634603aer_i_e
aeries64737783aer_ies
agonise83112693agonise
aiolis6316843aiolis_
airbus848343airbus_
airbuses1067083airbuses
airdate8311323airdate
airers64922313airers_
airest63825263air_est
airfare1047243airfare
airhole1048273airhole
airier64619363air_ier
airiest74221013airiest
airily93014823air_ily
airing74927503air_ing
airless73712043airless
airlift1048583airlift
airliner836953airliner
airlines8312793airlines
airns55521033air_ns_
airpost939243airpost
airs46447423air__s_
airsick1395333airsick
airths95414253airths_
airtimes1037503airtimes
airting83616303airting
airts55626343air_ts_
airward1148133airward
airwaves1444723airwaves
airway1237693airw_ay
airways1336243airways
airwomen1344823airwomen
alewife1344923alewife
amortise10428513amortise
anise55129703a__nise
aorist64827873aor_ist
appraise1247703appraise
apprise11310193apprise
ariose64818723a_riose
arisen65316793a_r_isen
arises65233803a_r_ises
arkose104911343a_rkose
armies85123693a_rmies
arose55832083a_r_ose
arouse65019983a_rouse
arris56824683a_rris_
arrises71617583a_rrises
arrive91311793a_rrive
arse46539273a_r__se
arsine64021043a_rsine
arsis55722423a_rsis_
artist64125543a_rtist
artiste73813693a_rtiste
atomise93013823atomise
auris55331533aur_is_
aurist65027253aur_ist
azotise1637073azotise
bairnish1345473bairnish
birdie94013783birdi_e
birdies104016213birdies
birkie124110133birki_e
birkies133712433birkies
birse74517403bir__se
braise84318753_braise
bruise83412873_bruise
cerise84822043cer_ise
cirrose937473cirrose
cruise84314043_cruise
dairies84217733dair_ies
dirties83119383dirties
endwise1136463endwise
fairies103516043fair_ies
fairish1338993fair_ish
fairyism1643513fairyism
fanwise1336633fanwise
fraise94214913_fraise
frise85322453_fr_ise
girlie73711463girli_e
girlies83013703girlies
girlish1137193girlish
hairlike1536673hairlike
hairline1137873hairline
hircine1239143hircine
incise83515333_incise
iodise74214943_iodise
ionise63516943_ionise
iris45732553_ir_is_
irised73913153_ir_ised
irises64221173_ir_ises
iwis77117013_i_wis_
kiwis12328583ki_wis_
laicise939333lai_cise
liaise6310693li_aise
likewise1543263likewise
lionise7310373lionise
manwise1239183manwise
midwife16225523midwife
misraise10410523misraise
mortise9713533mortise
nicoise937933nicoise
nowise9511073_nowise
overwise141810253overwise
palewise1346423palewise
parvise124211693parvise
praise84419413_praise
prise74632613_pr_ise
raise54828053__raise
reraise7316313reraise
rerise64325633rer_ise
rise45945233__r_ise
satirise8310683satir_ise
sidewise1245353sidewise
sunwise1036433sunwise
surmise9311083surmise
taxwise1734253taxwise
unwise9510803_unwise
upraise9158603upraise
uprise82313693upr_ise
virile9313433vir_ile
warpwise1642853warpwise
wise75737343___wise

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.470380193.6
2DLD Change Limit1340271317.07618941.1
3Display Results1311310.0502620.0
 (SQL Overall)1786911317.59623524.4
 
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.