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

44 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
pyromorphites256276(None) 
pyromorphite2463531pyromorphite_
zygomorphies321974353zygomorphi_es
apomorphines2153044_apomorphines
endomorphies2054534endomorphi_es
mesomorphies2153904mesomorphi_es
pleomorphisms2463324pleomorphisms
pyrophosphates2671514pyrophosphates
allomorphisms22133305allomorphisms
apomorphine2053785_apomorphine_
automorphisms22133795automorphisms
chromophores2454245chromo_phores
chromospheres2562935chromospheres
endomorphisms2363475endomorphisms
homomorphisms2463285homomorphisms
homophiles2048225__homo_philes
hydromorphic2864075hydromorphi__c
hypomorphic2854825hypomorphi__c
hypomorphs2554215hypomorph___s
isomorphisms2162855_isomorphisms
meromorphic2265305meromorphi__c
monomorphisms2163195monomorphisms
morphines1648235____morphines
paedomorphisms2672945paedomorphisms
paedomorphoses2482175paedomorphoses
paramorphs1954255paramorph___s
perimorphs1953995perimorph___s
phlogopites1953075phlogo_p_ites
phosphites2087045p___hosphites
pleomorphic2255035pleomorphi__c
pleomorphism2364195pleomorphi_sm
polymorphisms2762925polymorphisms
promotes12314125p_romo____tes
prototrophies2064665p_rototrophi_es
pyrologies16310015pyrolo__gi_es
pyrolusites1652395pyr__olusites
pyromancies2054875pyrom_anci_es
pyrometries1898125pyrom_etri_es
pyrophosphate2571595pyrophosphate_
pyrophyllites26112025pyrophyllites
pyroxenites2353825pyr__oxenites
pyrrhotites1951625pyrrho__tites
spermophiles2153075sper_mo_philes
zygomorphic332585665zygomorphi__c

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 Filter1786911247900.406440125.6
2DLD Change Limit124790447.93615724.5
3Display Results44440.0331333.3
 (SQL Overall)178691448.37521336.2
 
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.