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

51 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
stromatolites156210(None) 
stromatolite1462361stromatolite_
stromatolitic17112022stromatolitic
chromatolyses2361934chromatolyses
statoliths1353454st___atoliths
stomatitides1552044st_omatitides
stomatitis1254744st_omat__itis
stomatitises1452844st_omatitises
tremolites1256044_trem__olites
aromaticities1754715_aromaticities
aromatizes2159195_aromat__izes
astrometries1455515astromet_ri_es
chromaticities2362835chromaticities
chromatolysis2362235chromatolysis
chromatolytic2562555chromatolytic
crematories1546855_crematori_es
crocidolites1751425_crocidolites
graptolites1452965_gr_aptolites
sarcomatoses1652365sarcomato__ses
sarcomatosis1662365sarcomatosi__s
scapolites1455695s___capolites
sodalites10128695s__oda__lites
somatologies1546235s__omatologies
somatotypes1851945s__omatotypes
spermatocytes2262305spermatocytes
statolith1245535st___atolit_h
staurolites1152595st__aurolites
steatites939845st__eat__ites
stigmatizes2353645stigmat__izes
stomates10313345st_oma____tes
stomatopods1662035st_omato_pods
stomatous1146075st_omato___us
stoolies8311085st_o___oli_es
stramonies1246655str__amoni_es
strandlines1244965str__andlines
strategies1155595str__ategi_es
strategizes2153195str__ategizes
stratifies1346745str__atifi_es
streamlines1343645str_ea_mlines
stromatic13410195stromat__i__c
strontianites1361645strontianites
stylolites1343655st___ylolites
tomatilloes1352015_t_omatilloes
tomatoes1038615_t_omato___es
trampolines1543895_tram_polines
trematodes1343505_tremato__des
tremolite1156895_trem__olite_
triathletes1472285_tr_iathletes
troilites948435_tro___ilites
troostites1044535_troost__ites
trotlines939105_tro__t_lines

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790519.61012985.4
3Display Results51510.0461108.7
 (SQL Overall)178691519.81218211.5
 
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.