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

81 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
aboulic115628(None) 
aboulia966551aboulia
abulic106411421ab_ulic
aboulias1065542aboulias
abulia83512502ab_ulia
aulic74420242a__ulic
tabouli945842tabouli_
taboulis1045042taboulis
abelia83114403ab_elia
abiotic11510463abiotic
aboil72217543abo__il
abolish12311503abo_lish
abolla8410193abo_lla
abollae936943abollae
abought1346143abought
abound9239863abou_nd
abounds10217083abounds
about75229083abou__t
abulias93210693ab_ulias
acoustic1246443acoustic
acrylic1496283acrylic
acyclic1345573acyclic
aeonic83517043aeo_nic
afoul8510193afoul__
agonic93515143ago_nic
agouti7388773agouti_
agoutis8286873agoutis
aioli5318313aio_li_
aiolis6316843aio_lis
alkalic13146973alkalic
alkylic16174233alkylic
allelic9118173allelic
allylic12155843allylic
aloetic9313183aloetic
amoebic1346153amoebic
amylic13108713a_mylic
anabolic1246213anabo_lic
angelic1039623angelic
annuli6459053annuli_
anodic92813133ano_dic
anomic102516303ano_mic
anosmic1137783anosmic
anoxic152610673ano_xic
anuric8812103a_nuric
aortic8316613a_ortic
apogeic1246603apogeic
atelic8313703a_telic
atomic104115603ato_mic
atonic83420473ato_nic
atopic103514143ato_pic
auric74521733a__uric
axonic154312723axo_nic
azoic162912063azo__ic
azonic175513153azo_nic
azotic172711633azo_tic
basilic1137493basilic
beylic1337823_beylic
bollix1538053_bollix
boric98024223_bo_ric
botulin947653_botulin
boudin9412373_boudin
bougie93613273_bougie
boule74828043_boul_e
boules84925973_boules
boulle84614613_boulle
carbolic1448323carbo_lic
colic95726173_co_lic
coulis84018763_coulis
diabolic1345733diabo_lic
ecbolic1345623ecbo_lic
embolic1347423embo_lic
enolic8413353eno_lic
folic105319323_fo_lic
frolic1149203fro_lic
ghoulie1144263ghoulie
moulin8313283_moulin
oboli73712873obo_li_
tabouleh1342793tabouleh
tabuli839363tab_uli_
tabulis938833tab_ulis
toluic837693_toluic

Search took 7 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 Limit134027816.14021828.5
3Display Results81810.0302700.0
 (SQL Overall)178691816.57627173.2
 
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.