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

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

59 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
photobiological2564451photobiological_
photobiologic2365203photobiologic___
photogeological2463103photogeological_
paleobiological2264734paleobiological_
photobiologies2265154photobiologi__es
photobiologist2266224photobiologi__st
photobiologists2365174photobiologi_sts
aerobiological1955135_aerobiological_
cryobiological2463925_cryobiological_
exobiological2554725__exobiological_
hydrobiological2763585hydrobiological_
microbiological2464375microbiological_
neurobiological20123925neurobiological_
nonbiological1855265_no_nbiological_
phonological2058375ph__o_nological_
photobiology2384015photobiolog____y
photogeologic2263735photogeologic___
physiological2455575ph__ysiological_
prebiological2055975p__rebiological_
radiobiological2163345radiobiological_
sociobiological2273515sociobiological_
soteriological1763895_soteriological_
abiological1647836____abiological_
bacteriological2282866bacteriological_
biological15128886_____biological_
biologicals16105026_____biologicals
chronobiologic2472016chronobiologic___
chronological2175956ch_ro_nological_
cohomological2354086_coho_mological_
entomological1855036_ento_mological_
etiological1448416__et__iological_
hagiological1955816_h__agiological_
homological1948456_h__o_mological_
horological1748286_h__o_rological_
nonbiologically2383066_no_nbiologically
paleobiologic2064786paleobiologic___
paleoecological2263556paleoecological_
paleontological2063846paleontological_
paleozoological2963266paleozoological_
pathological2047986p_at__hological_
petrological1758596p_et__rological_
pharmacological2793546pharmacological_
phenological2068056ph___enological_
philological2046376ph___ilological_
phonologically2555556ph__o_nologically
photogeologies2163896photogeologi__es
photogeologist21134676photogeologi__st
photogeologists22173646photogeologi_sts
phraseological2283696ph_raseological_
phrenological2156336ph__renological_
phycological2546946ph___ycological_
physiologically2993606ph__ysiologically
pomological1848036p___o_mological_
proctological2055826p__roctological_
pteridological2053596p__teridological_
sociological1747506___sociological_
topological1647436___to_pological_
toxicological2553986___toxicological_
tribological1745986___tribological_

Search took 5 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 Filter178691658740.360496363.9
2DLD Change Limit65874594.25015499.8
3Display Results59590.0461282.6
 (SQL Overall)178691594.65638378.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.