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

99 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
acholias134957(None) 
acholia1239971acholia_
aphonias132611142aphonias
cholas114818002_chol_as
chollas123811352_chollas
scholia1237832scholia_
scholiast1446302scholiast
abelias93213563a_belias
aboulias1065543aboulias
abrosias1049033abrosias
abulias93210693a_bulias
acacias11510403ac_acias
acapnias1255683acapnias
accidias1346333accidias
acedias1039773ac_edias
acequias1943973acequias
acerolas1048053acerol_as
achalasias1553843achalasias
achenial1348283achenial
achilleas1443263achilleas
acrasias1048893acrasias
acroleins1145543acroleins
acrolith1348453acrolith
acroliths1445113acroliths
acromia1139963acromia_
acromial1248463acromial
acrylics1584363acrylics
actinias101810843actinias
acyloins1345903acyloins
aeolian738623a_eolian
agnosias947243agnosias
aholds10469483a_hol_ds
aiolis6316843a_ioli_s
alcoholics1762143alcoholics
alias55834603a___lias
ammonias1247953ammonias
anchovies1745753anchovies
anopias92412483a_nopias
anoxias14259113a_noxias
aphagias14237343aphagias
aphasias132710433aphasias
aphelia1249423aphelia_
aphelian1376963aphelian
aphonia122711883aphonia_
aphonics15259523aphonics
aporias9315153a_porias
areolas71013863areol_as
atonias73315993a_tonias
cachexias2363383cachexias
camelias12510303camelias
canolas9313993canol_as
catholics16105893catholics
challas124414123_challas
chelas113817203_chel_as
chias104625523_ch__ias
chiliad1337563_chiliad
chiliads1445853_chiliads
chiliasm15134513_chiliasm
chiliast13117933_chiliast
chilies124218303_chilies
chilis115517873_chili_s
choirs114911883_cho_irs
chola104718033_chol_a_
choleras13289043_choleras
cholers124215203_cholers
choline122915383_choline
cholines132214493_cholines
cholla113911023_cholla_
cholos114716853_chol_os
chopins142312243_chopins
choreas124414203_choreas
chorial124214143_chorial
cobias104014993_c_obias
colas75436773_c_ol_as
colics104219903_c_olics
colies84837053_c_olies
colins85229043_c_olins
colzas174010513_c_olzas
coolies93824963_coolies
dahlias1135723dah_lias
ecbolics1444003ecbolics
echolalias1553123echolalias
echoless1345603echoless
ectopias1248273ectopias
holies94630033__holies
hollas94616903__hollas
magnolias1244723magnolias
mahonias1348063mahonias
pachalics1844983pachalics
pachoulis1643613pachouli_s
phobias14228183_phobias
scholar1236953schol_ar
scholars1336683scholars
scholiasts1544093scholiasts
scholium1545643scholium
scholiums1644843scholiums
scotias939753sc_otias
thorias102312053_thorias
thulias1035743_thulias

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 Filter1786911461620.423422437.4
2DLD Change Limit146162997.46619577.0
3Display Results99990.0333000.0
 (SQL Overall)178691997.92222556.3
 
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.