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

55 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
aphagias1423735(None) 
aphagia13247661aphagia_
aphasias132710441aphasias
aphasia122510872aphasia_
aphasiac15286592aphasiac
aphasiacs16254222aphasiacs
aphasics15257242aphasics
aphonias132611142aphonias
aplasias10279232aplasias
apraxias1746332apraxias
abasias9711013a_basias
acacias11510403a_cacias
acholias1349573acholias
acrasias1048893acrasias
adagial946373a_dagial
adagios945513a_dagios
analgias9107803analgias
anergias947173anergias
angarias9310553angarias
aphanite1348773aphanite
aphanites1448273aphanites
aphasic142810063aphasi_c
aphelia1249423aphelia_
aphelian1376963aphelian
aphesis12610513aphesi_s
aphidian1445533aphidian
aphidians1544053aphidians
aphids125110843aph__ids
aphis105917133aph__i_s
aphonia122711883aphonia_
aphonics15259523aphonics
apiarian1048323apiarian
apiarians1146653apiarians
apiaries10312733apiaries
apimanias1345113apimanias
aplasia92510803aplasia_
apologias1247503apologias
aporias9315153ap_orias
apraxia1646893apraxia_
arcadias1149163arcadias
asphyxias2452623asphyxias
assagais943813assagais
astasias8410143astasias
ataxias14189343a_taxias
daphnias1444683daph_nias
dysphagias2053063dysphagias
geophagias1753713geophagias
omophagias1853653omophagias
patagia1068783patagia_
patagial1157173patagial
phages125213513_phag_es
phasis114614923_phasi_s
phobias14228183_phobias
raphias123511083raph__ias
sharias102516003_sharias

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.500357382.0
2DLD Change Limit146162557.23320207.7
3Display Results55550.0331666.7
 (SQL Overall)178691557.76623009.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.