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

65 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
anthophyllites2513181(None) 
anthophyllite24192261anthophyllite_
apophyllites2261893a__pophyllites
aminophyllines24131354aminophyllines
apophyllite2162464a__pophyllite_
pyrophyllites26112024_pyrophyllites
theophyllines2461234__theophyllines
xanthophylls3061234xanthophyll___s
aminophylline23141665aminophylline_
anophelines1653735an__oph_elines
anthophilous2062545anthoph_il_ous
aphyllies1743825a____phylli_es
autophytes1846055aut_ophy___tes
entophytes1854615ent_ophy___tes
heterophyllies2592315heterophylli_es
lithophytes22102995lithophy___tes
phyllites1745325_____phyllites
pyrophyllite25112615_pyrophyllite_
theophylline2361535__theophylline_
xanthophyll2961235xanthophyll____
aerophytes1847156a_erophy___tes
anaphylaxes2651596an__aphy_laxes
anchorites1547756ancho____rites
anhydrites1792736an____hydrites
anopheles1446646an__oph_el__es
anopheline1554106an__oph_eline_
anthelices1546436ant___h_elices
anthelixes2044886ant___h_elixes
anthocyanins2062256antho_cyani_ns
anthologies151012016antho___logies
anthologizes253038396antho__logizes
anthracites1674956ant___hracites
anthranilates1662126anth_ranilates
anthropologies20113986anthrop_ologies
antielites10410346ant____ielites
antihelices1655446ant__ih_elices
antihelixes2154236ant__ih_elixes
antiphonies1656266ant_iph_oni_es
antipyrines1654746ant_ip_y_rines
antisatellite13102186antisatellite_
antonymies1555026ant_o_ny_mi_es
asphaltites1652456a___sphaltites
astrophysics2263426astrophy_si_cs
atrophies14410096a_troph___i_es
autophagies1754136aut_oph_agi_es
autophyte1745926aut_ophy___te_
endophytes1954906en_dophy___tes
entomophilies2062256entomoph_ili_es
entophyte1754566ent_ophy___te_
homophylies2455156_homophy_li_es
hoplites13310546___hop___lites
interpellates1554876interp_ellates
lithophyte2163116lithophy___te_
monophylies2155356_monophy_li_es
natrolites1047416natro____lites
neophytes1745946_n_eophy___tes
nephelites1544826_n__eph_elites
ophiolites1544196____ophiolites
phyllite1645746_____phyllite_
podophyllins2362126_podophylli_ns
propylites1746306__prop_y_lites
tachylites1843596__t_achy_lites
toxophilites2451896_toxoph_ilites
trophallaxes2471826__trophallaxes
trophozoites2672126__trophozoites

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.406440125.6
2DLD Change Limit124790659.36013332.3
3Display Results65650.0461413.0
 (SQL Overall)178691659.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.