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

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

81 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
zygomorphies32197435(None) 
zygomorphic332585652zygomorphi_c
endomorphies2054533endomorphies
mesomorphies2153883mesomorphies
pyromorphites2562723pyromorphites
zygomorphy3362063zygomorph__y
apomorphines2153034_apomorphines
hypomorphic2854814hypomorphi_c
hypomorphs2554214hypomorph__s
lagomorphs1853094lagomorph__s
pyromorphite2463514pyromorphite
zoomorphic2854414z_oomorphi_c
zoomorphs2553704z_oomorph__s
actinomorphies2372025actinomorphies
allomorphic2054665allomorphi_c
allomorphism21134335allomorphism
allomorphisms22133305allomorphisms
allomorphs1754215allomorph__s
apomorphine2053765_apomorphine
automorphism21115185automorphism
automorphisms22133795automorphisms
autotrophies1756015autotrophies
auxotrophies2453935auxotrophies
biomorphic2154935_biomorphi_c
biomorphs1844195_biomorph__s
dynorphins1952765dy__norphins
dystrophies2053765dystro_phies
ectomorphic2254715ectomorphi_c
ectomorphs1954245ectomorph__s
endomorphic2155015endomorphi_c
endomorphism2264585endomorphism
endomorphisms2363475endomorphisms
endomorphs1855085endomorph__s
geomorphic2055605_geomorphi_c
halomorphic2354355halomorphi_c
homomorphic2554635homomorphi_c
homomorphism2364235homomorphism
homomorphisms2463285homomorphisms
homophiles2048175__homo_philes
hydromorphic2864065hydromorphi_c
hypomorph2453685hypomorph___
idiomorphic2153505idiomorphi_c
isomorphic1954765_isomorphi_c
isomorphism2053695_isomorphism
isomorphisms2162855_isomorphisms
isomorphous1852205_isomorphous
isomorphs16144285_isomorph__s
kymographies2754485kymographies
lagomorph1752815lagomorph___
logomachies1951785logom_achies
meromorphic2265265meromorphi_c
mesomorphic2254685mesomorphi_c
mesomorphs1953885mesomorph__s
monomorphic2255115monomorphi_c
monomorphism2054145monomorphism
monomorphisms2163185monomorphisms
morphias1546805____morphias
morphines1648175____morphines
morphins1538595____morphins
murphies1536415____murphies
neomorphs1654935_neomorph__s
nomarchies1744105__nomarchies
nomographies20126585__nomographies
pleomorphic2255015pleomorphi_c
pleomorphism2364185pleomorphism
pleomorphisms2463325pleomorphisms
sycomores1644265sycomor___es
theosophies1984385theoso_phies
tomographies20127335__tomographies
typographies23105665typographies
xylographies2855265xylographies
zoogeographies301864575zoogeographies
zoographies2645805z_oographies
zoomorph2453355z_oomorph___
zoophiles2356515z__o_o_philes
zygapophyses3561225zygapo_physes
zygomatics2753085zygom__atics
zygosities2343105zyg__osities
zygospores2562275zyg__ospores
zymologies2546375zy__mologies
zymurgies241963155zy__mur_gies

Search took 11 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.1401276364.3
2DLD Change Limit148819819.97014926.7
3Display Results81810.0461760.9
 (SQL Overall)1786918110.15617594.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.