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

72 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
aboulia96655(None) 
aboulias1065541aboulias
aboulic1156281aboulic
abulia83512501ab_ulia
abelia83114402ab_elia
abolla8410192abo_lla
abulias93210692ab_ulias
abulic106411422ab_ulic
tabouli945842tabouli_
taboulis1045042taboulis
abasia8712953ab_asia
abelian92810643ab_elian
abelias93213563ab_elias
aboil72217543abo__il
abolish12311503abo_lish
abollae936943abollae
aboma91114603abo__ma
abomasa11114613abomasa
abought1346143abought
abound9239863abou_nd
abounds10217083abounds
about75229083abou__t
abrosia939273abrosia
acholia1239973acholia
aeolian738623aeo_lian
afoul8510193afoul__
agouti7388773agouti_
agoutis8286873agoutis
aioli5318313aio_li_
aiolis6316843aio_lis
alluvia1045193alluvia
alodia71112453alo_dia
alula5317093a_lul_a
ampulla1164303ampulla
amusia839173a_musia
annuli6459053annuli_
anopia83412393ano_pia
anopsia9258443anopsia
anosmia946643anosmia
anoxia133510023ano_xia
anuria6313123a_nuria
aphelia1249423aphelia
aporia8315863apo_ria
atonia63816513ato_nia
aulic74420243a__ulic
azoturia1742813azoturia
bacula103112673bacul_a
boccia12338793_boccia
bola66035563_bo_l_a
bollix1538053_bollix
botulin947653_botulin
boudin9412373_boudin
bougie93613273_bougie
boule74828043_boul_e
boules84925973_boules
boulle84614613_boulle
boyla102912363_boyl_a
bulla74620563_b_ulla
coulis84018763_coulis
doula65717773_doul_a
dulia61014983__dulia
folia83618933_fo_lia
ghoulie1144263ghoulie
lobelia947213lobelia
moulin8313283_moulin
obelia8329453ob_elia
oboli73712873obo_li_
peculia1147133peculia
tabouleh1342793tabouleh
tabuli839363tab_uli_
tabulis938833tab_ulis
thulia936113_thulia

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.406440125.6
2DLD Change Limit134027727.01319111.2
3Display Results72720.0332181.8
 (SQL Overall)178691727.45223978.9
 
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.