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

127 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
airhole104827(None) 
airholes1138031airholes
areole61017282a_reole
armhole1236942armhole
asshole1046792asshole
aureole738692aureole
oilhole1046262oilhole
piehole12188552piehole
pinhole122010432pinhole
aerobe8412403aer_obe
ahold94714253a__hold
aioli5318313ai__oli
airboat9512133airboat
airborne1044513airborne
airdate8311323airdate
airdrome1144983airdrome
airfare1047243airfare
airflow1343543airflow
airfoil1044463airfoil
airfoils1144003airfoils
airglow1143673airglow
airhead1136993airhead
airily93014823air_ily
airlike11310333airlike
airline7315033airline
airmobile1342283airmobile
airport9511383airport
airpost939243airpost
airpower1343983airpower
airshot1059493airsho_t
airshots1145943airshots
airshow1344623airsho_w
airshows1444163airshows
airtime948063airtime
airwave1344433airwave
airwise1036713airwise
airwomen1344823airwomen
aisle55223193ai__sle
amitrole1045173amitrole
amole75724593a__mole
anethole1146253anethole
anisole71010833anisole
anole55330383a__nole
arable81821003a_rable
areola6813673a_reola
areolae7811733a_reolae
areoles71016953a_reoles
argle65421563a_r_gle
argol65317263a_rgol_
argols74514613a_rgols
argyle1066063a_rgyle
ariose64818723a_riose
arkose104911343a_rkose
armholes1347383armholes
arose55832083a_r_ose
ashore9414613a_shore
assholes1146743assholes
aureola747033aureola
aureolae845313aureolae
aureoled945743aureoled
aureoles838283aureoles
auricle9139813auricle
awhile1257793a_while
azole145118033a__zole
birle75023633bir__le
borehole1347623borehole
bricole112810493bricole
cabriole1276933cabriole
capriole1276913capriole
cariole9818343cariole
carriole1089863carriole
cineole91010003cineole
circle1039703cir_cle
cirrose937473cirrose
citole8311503ci_tole
creole8913733_creole
dariole8711163dariole
dhole95215363__dhole
diazole1736793diazole
dipole91112853di_pole
eyehole1346003eyehole
fishpole1644053fishpole
foxhole2045073foxhole
frijole1734583frijole
girasole984423girasole
girdle82110463gir_dle
girolle835793girolle
hirable121612313hirable
hirple11158973hir_ple
hirsle9159573hir_sle
hole77553393___hole
indole74516053_indole
inhale9411513_inhale
insole63515863_insole
irone55126363_ir_one
keyhole1764433keyhole
kirtle10309473kir_tle
liriope944043liriope
manhole12311343manhole
midsole1037813midsole
miracle1138843miracle
mudhole1344913mudhole
oilholes1146153oilholes
oriole6814293_oriole
parole84425253par_ole
pieholes13168913pieholes
pinholes131810663pinholes
pinole83218783pi_nole
pishoge1336693pishoge
pistole92414313pistole
porthole1349523porthole
pothole12312173pothole
prole74527793_pr_ole
pyrrole1246033pyrrole
rathole10312053rathole
rissole739783rissole
role45851823__r_ole
safrole1037253safr_ole
sinkhole1594383sinkhole
taphole1239773taphole
thole85620843__thole
variole10711593variole
virgule1144283virgule
virile9313433vir_ile
whole114418093__whole
wirable121610963wirable
wormhole1644663wormhole

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.406440125.6
2DLD Change Limit1340271277.58017681.7
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.03222247.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.