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 “zoophobias” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
zoophobias265345(None) 
zoophobia2554001zoophobia_
homophobias2354732homophobias
zoophilias2454002zoophilias
zoophobes2545282zoophob_es
acrophobias2053933acrophobias
homophobia2255213homophobia_
phobias14228183___phobias
photophobias2455123photophobias
xenophobias2593243xenophobias
zoophilia2354653zoophilia_
zoophilies2444803zoophilies
zoophobe2445113zoophob__e
acrophobia1954424acrophobia_
agoraphobias2081694agoraphobias
aphonias132611144__aphonias
apophonies1756524apophonies
biophilias1754214biophilias
colophonies1855634colophonies
dysphonias1954464dysphonias
dysphorias1953794dysphorias
epopoeias1353974epop_oeias
euphorbias17102394_euphorbias
euphorias1466284_euphorias
geophagias1753714geophagias
gomphosis1744454gomphosi_s
homophobes2246564homophob_es
homophobic2455654homophobi_c
homophonies2156514homophonies
hydrophobias2693834hydrophobias
loopholes1448894loopho_les
loopholing1653754loopholing
lyophobic2144844lyophobi_c
monophonies1846594monophonies
morphias1546844morph__ias
morphosis1646444morphosi_s
negrophobias2063084negrophobias
neophilias15115734neophilias
omophagias1853654omophagias
phobia13278604___phobia_
phobics16286704___phobics
photophobia2355614photophobia_
porphyrias2094244porphyrias
trophoblast1863454trophoblast
xenophobia2453544xenophobia_
zoochores2345954zoocho_res
zoogloeas1941994zooglo_eas
zoologies1939014zoo_logies
zoomanias2044344zoo_manias
zoonosis1744394zoo_nosi_s
zoophile2246454zooph__ile
zoophiles2356524zooph_iles
zoophilic2545084zoophili_c
zoophilous2452844zoophilous
zoophily2544914zooph__ily
zoophytes2644964zooph_ytes
zoophytic2844654zoophyti_c
zootomies2046144zoo_tomies

Search took 10 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 Filter1786911614500.440406115.9
2DLD Change Limit161450589.20317543.2
3Display Results58580.0134461.5
 (SQL Overall)178691589.65618505.7
 
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.