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

49 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
apodosis114658(None) 
apodoses1136651apodoses
acidosis1146142acidosis
apoapsis1244102apoapsis
apodous1037402apodo_us
apoptosis1345362apoptosis
abiosis939383a_biosis
acidoses1136773acidoses
adenosis946343adenosis
adiposis1146253adiposis
adonis7314063a__donis
aldoses8311203a_ldoses
alphosis1347273alphosis
amitosis1047213amitosis
anemosis10148073anemosis
aphesis12610513ap_hesis
apoapses1244723apoapses
apocopes1445993apocopes
apocopic1645823apocopic
apods86316343apod___s
apologia1147723apologia
apologias1247503apologias
apologies12311193apologies
apologise1248303apologise
apologist12412403apologist
apologs1038593apolo_gs
apomixis1942923apomixis
apophasis1646993apophasis
apophysis1956023apophysis
apoptoses1346443apoptoses
apotheosis1553653apotheosis
apposes11511473ap_poses
apsis75718293ap___sis
gaposis1038423gap__osis
haplosis1347093hap_losis
lordosis944453lordosis
papooses1248053papo_oses
pocosin1169643_pocosin
pocosins1258953_pocosins
podsols1056513_podsols
pooris83916843_po_oris
ptosis83611823_p_tosis
pyosis114012133_p_yosis
pyrosis12411653_pyrosis
sorosis72611973_sorosis
spodosol1142223spodosol
spodosols1242313spodosols
whoosis1335453who_osis
zoonosis1744393zoonosis

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.436409841.7
2DLD Change Limit146162498.47017256.4
3Display Results49490.0301633.3
 (SQL Overall)178691498.93619996.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.