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

33 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
homophonous215368(None) 
homophones2048392homophon_es
homophonies2156522homophonies
cacophonous2052463cacophonous
homogenous1654923homo_genous
homologous1654133homo_logous
homophobes2246573homopho_bes
homophobias2354743homophobias
homophone1947843homophon__e
homophonic2256993homophon_ic
homophony2244783homophon__y
homopterous1853593homopterous
homosporous1852203homosporous
polyphonous2153243polyphonous
colophonies1855634colophonies
colophons1646994colophon__s
homogamous1853574homo_gamous
homogeneous1753874homogeneous
homogonies16107734homo_gonies
homonymous2053144homo_nymous
homophiles2048234homoph_iles
homophobe2146154homoph__obe
homophobia2255214homopho_bia
homophobic2455654homopho_bic
homophylies2455164homophylies
homozygous2852224homo_zygous
hoopoos1298544ho_op_o_o_s
monophagous1953374monophagous
monophonies1846594monophonies
monotonous1254934mono_tonous
phosphorous2173944pho_sphorous
symphonious2153054sym_phonious
zoophilous2452844zo_ophilous

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 Filter1786911488190.406440125.6
2DLD Change Limit148819339.06316420.5
3Display Results33330.0132538.5
 (SQL Overall)178691339.48218845.3
 
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.