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

115 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
airholes113803(None) 
airhole1048271airhole_
areoles71016952a_reoles
armholes1347382armholes
assholes1146742assholes
aureoles838282aureoles
oilholes1146152oilholes
pieholes13168912pieholes
pinholes131810662pinholes
aerobes9311493aer_obes
aholds10469483a__holds
aiolis6316843ai__olis
airboats1047283airboats
airbuses1067073airbuses
airdates939713airdates
airdromes1244383airdromes
airfares1146693airfares
airflows1443833airflows
airfoils1144003airfoils
airglows1243453airglows
airheads1246133airheads
airless73712043air__less
airlines8312793airlines
airports1046463airports
airposts1045923airposts
airpower1343983airpower
airpowers1443473airpowers
airshots1145943airsho_ts
airshows1444163airsho_ws
airtimes1037503airtimes
airwaves1444723airwaves
airwomen1344823airwomen
aisles64721143ai__sles
amitroles1144723amitroles
amoles84122193a__moles
anetholes1246673anetholes
anisoles81010123anisoles
anoles64827423a__noles
arables91814973a_rables
arbores94016033a_rbores
areolas71013863a_reolas
areole61017283a_reole_
argles75218483a_r_gles
argols74514613a_rgol_s
argyles1136053a_rgyles
arkoses113910833a_rkoses
arles56735743a_r__les
armhole1236943armhole_
asshole1046793asshole_
aureolas846853aureolas
aureole738693aureole_
aureoled945733aureoled
auricles10138333auricles
azoles154614613a__zoles
birles84920643bir__les
boreholes1447353boreholes
bricoles122610303bricoles
cabrioles1376363cabrioles
caprioles1376753caprioles
carioles10817073carioles
carrioles1169473carrioles
cineoles10109403cineoles
circles1139903cir_cles
cirrhoses1443873cirrhoses
citoles9312553ci_toles
creoles9913323_creoles
darioles9710693darioles
dholes104914793__dholes
diazoles1836323diazoles
dipoles101013753di_poles
eyeholes1445593eyeholes
fishpoles1743633fishpoles
foxholes2144693foxholes
frijoles1834373frijoles
girasoles1083713girasoles
girdles92210003gir_dles
girolles935523girolles
hirples12149643hir_ples
hirsles101510073hir_sles
holes84748653___holes
indoles83716363_indoles
inhales10511863_inhales
insoles73516243_insoles
irones64724013_ir_ones
keyholes1844593keyholes
kirtles11309663kir_tles
liriopes1043883liriopes
manholes13311183manholes
midsoles1137763midsoles
miracles1238333miracles
mudholes1444873mudholes
oilhole1046263oilhole_
orioles7412993_orioles
paroles95025883par_oles
piehole12188553piehole_
pinhole122010433pinhole_
pinoles93418703pi_noles
pishoges1446953pishoges
pistoles102514723pistoles
portholes14410373portholes
potholes13312933potholes
proles84627203_pr_oles
pyrroles1345453pyrroles
ratholes11312413ratholes
rissoles839113rissoles
roles56747983__r_oles
safroles1136933safr_oles
sinkholes1684323sinkholes
tapholes1339623tapholes
tholes94919783__tholes
varioles11711123varioles
virgules1244333virgules
viroses10310533vir_oses
wholes124616773__wholes
wormholes1744613wormholes

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.1731032896.0
2DLD Change Limit1461621157.92318447.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.14221946.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.