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

295 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
airlike1131033(None) 
airline7315031airline
hairlike1536671hairlike
airlift1048582airlift
airliner836952airliner
airlines8312792airlines
airtime948062airtime
airwise1036712airwise
alike95523962a__like
antlike11312072antlike
apelike13310532apelike
armlike1348552armlike
asslike1137372asslike
axlike17388852a_xlike
biblike1536892biblike
birdlike1535232birdlike
dislike122913452dislike
fairylike1942692fairylike
finlike14279062finlike
girlie73711462girli_e
hairline1137872hairline
hiplike1637602hiplike
jiglike19105332jiglike
kidlike1137062kidlike
liplike1337282liplike
mislike132914832mislike
niblike1336702niblike
oarlike113411192oarlike
piglike14157312piglike
riblike1337332riblike
stairlike1344752stairlike
taillike1237862taillike
tinlike11248802tinlike
waiflike1834572waiflike
warlike142410472warlike
wiglike15125852wiglike
wirelike15167492wirelike
aerie54634603aer_i_e
aerolite8315053aerolite
aguelike1344673aguelike
aiblins9311473aiblins
ailing74331013ai_ling
aioli5318313aioli__
aiolis6316843aioli_s
airdate8311323airdate
airfare1047243airfare
airhole1048273airhole
airier64619363air_ier
airily93014823air_ily
airing74927503air_ing
airless73712043airless
airlifted1343193airlifted
airlifts1143633airlifts
airliners945983airliners
airplane1067793airplane
airsick1395333airsick
airstrike1384143airstrike
airtimes1037503airtimes
airting83616303airting
airwave1344433airwave
aisle55223193aisl__e
aline57243153a__line
alive85722513a__live
alkie95520033a__lkie
alsike1047913a_lsike
anglice1089213anglice
aniline7418473aniline
aplite8316393a_plite
apronlike1543453apronlike
arise56436433a_r_ise
arrive91311793a_rrive
arrowlike1642413arrowlike
arsine64021043a_rsine
auntlike1234983auntlike
baglike14338943baglike
bailie83818363bai_li_e
balmlike1655353balmlike
barnlike1437183barnlike
basinlike1553383basinlike
batlike133311883batlike
bearlike14156793bearlike
bedlike14369533bedlike
beelike13379783beelike
belike124616283_belike
berline93716853berline
billie85019173billi_e
birdie94013783birdi_e
birdlife1443483birdlife
birdlime1343563birdlime
birkie124110133birki_e
birle75023633birl__e
birling104317053birling
bowlike16349473bowlike
boxlike20267073boxlike
budlike14257873budlike
cagelike1537723cagelike
calflike1735153calflike
carline93923613carline
catlike132712933catlike
cavelike1738213cavelike
cigarlike1642333cigarlike
cilice103213353ci_lice
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
cuplike1537213cuplike
dawnlike1634673dawnlike
deerlike1335723deerlike
dirgelike1543213dirgelike
dirling93316073dirling
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
disliked14288543disliked
disliker13358643disliker
dislikes132810843dislikes
doglike13207453doglike
eellike1138233eellike
elflike1435133elflike
epiclike1644143epiclike
eyelike1436973eyelike
fadlike15318483fadlike
fanglike1636823fanglike
fanlike142610503fanlike
fatlike142911193fatlike
faunlike1534763faunlike
fawnlike1844143fawnlike
ferlie92814053ferli_e
fernlike1535243fernlike
fiberlike1844113fiberlike
filmlike1734443filmlike
fishlike18225873fishlike
forklike1435813forklike
foxlike21226223foxlike
gamelike1538033gamelike
garpike1435093garpike
gatelike1337933gatelike
gemlike14206813gemlike
germlike1535093germlike
gillie74816943gilli_e
girlier8289523girlier
girlies83013703girlies
girlish1137193girlish
godlike1387563godlike
gumlike14317403gumlike
gutlike12308653gutlike
hairlines1237123hairlines
halolike1537403halolike
handlike1639153handlike
harelike1539613harelike
hatlike143311713hatlike
hawklike1734493hawklike
henlike1448693henlike
herblike1735883herblike
herdlike1636113herdlike
hipline12311423hipline
hircine1239143hircine
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
hornlike1536503hornlike
hutlike14349063hutlike
icelike1337173icelike
illite63414913_illite
inklike1037033inklike
iolite63221973_iolite
ironlike1235713_ironlike
ivylike1734283ivylike
jadelike2035993jadelike
jamlike20126923jamlike
jawlike21116003jawlike
jazzlike2742683jazzlike
jetlike18276763jetlike
killie104114893killi_e
kiltlike1134243kiltlike
kinglike1235093kinglike
kitelike1135733kitelike
lacelike1438493lacelike
ladylike1634683ladylike
lakelike1137383lakelike
lamblike1636153lamblike
lardlike1336503lardlike
lavalike1536283lavalike
lawlike14137073lawlike
leglike12136843leglike
lifelike15166223lifelike
like86040843___like
lilylike1543853lilylike
linelike12159003linelike
lionlike1234983lionlike
lordlike1345813lordlike
mainline1039863mainline
manlike133012783manlike
maplike15299273maplike
marline93320953marline
marlite92917073marlite
masklike1335593masklike
mastlike1437863mastlike
mazelike2336463mazelike
midlife13248303midlife
midline102315103midline
millime112511403millime
milline92519113milline
mislie83219153misli_e
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislive122812693mislive
netlike11308913netlike
nunlike11258073nunlike
nutlike113110113nutlike
oaklike10268003oaklike
oatlike113412403oatlike
owllike1435713owllike
oxlike17307473_oxlike
palmlike1656043palmlike
parklike1337483parklike
pealike131211273pealike
peglike14136773peglike
perlite9317313perlite
pinelike14188613pinelike
pipelike16166693pipelike
podlike14108553podlike
potlike13910123potlike
purline93516533purline
puslike1347563puslike
rashlike1535793rashlike
ratlike113912353ratlike
raylike14269253raylike
ringlike1336243ringlike
riverlike1644483riverlike
rodlike1288263rodlike
ruglike1236283ruglike
saberlike1544973saberlike
sacklike1337303sacklike
saclike131210123saclike
saintlike1344783saintlike
saltlike1237253saltlike
sandlike1339713sandlike
satyrlike1653513satyrlike
sawlike14138443sawlike
serflike1536273serflike
shrike134513243shr_ike
sighlike1635533sighlike
silkie103313403si_lkie
silklike1135523silklike
skinlike1134873skinlike
skirtlike1243003skirtlike
skylike1336103skylike
slitlike1235303slitlike
snaillike1343773snaillike
sonlike112110713sonlike
sparlike1437663sparlike
starlike1238813starlike
strike105619733str_ike
suitlike1236313suitlike
sunlike112310573sunlike
surflike1535933surflike
taglike12278913taglike
tanklike1136013tanklike
tapelike1437493tapelike
tealike111111083tealike
tidelike1336743tidelike
tigerlike1443533tigerlike
tilelike1237053tilelike
tillite7313563tillite
tirling83315733tirling
toelike11149823toelike
toylike14157243toylike
trike95320163_tr_ike
tublike1337083tublike
turflike1534443turflike
twiglike1642793twiglike
unalike11311533unalike
unlike102614063_unlike
urnlike1136713urnlike
vaporlike1843433vaporlike
vaselike1536993vaselike
veillike1534603veillike
veinlike1534313veinlike
virile9313433vir_ile
virilize2047743virilize
viruslike1642483viruslike
viselike1536923viselike
wartlike1537043wartlike
wasplike1734893wasplike
wavelike1836613wavelike
waxlike21185973waxlike
weblike1635923weblike
whiplike2043813whiplike
wifelike18135253wifelike
willie94116453willi_e
winglike1635593winglike
wisplike1734713wisplike
wormlike1735313wormlike

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272958.28016186.8
3Display Results2952950.1102681.8
 (SQL Overall)1786912958.54620909.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.