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

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

70 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
subatom114705(None) 
subatoms1245881subatoms
rubato8319682rubato_
rubatos9278652rubatos
sabaton937712sabaton
subatomic1543092subatomic
subitem1138552subitem
subito8410452subito_
abator84512723_abator
atom67824523___atom
baton75822423__baton
curator9312213curator
custom104010273cu_stom
diatom939453_diatom
fugato1036223fugato_
fugatos1135483fugatos
rabato83413263rabato_
rabatos93010903rabatos
rebato83714683rebato_
rebatos92913113rebatos
rubaboo1144093rubaboo
rubati8299693rubat_i
sabatons1037843sabatons
sabayon1244233sabayon
sacaton938993sacaton
satem76021463s__atem
senator7313073senator
sfumato1253683sfumato_
sfumatos1353343sfumatos
shalom11810923s_halom
skatol1035723s_katol
slalom888173s_lalom
stator64015483s_tator
stratum9318253stratum
suba64926603suba___
subabbot1143133subabbot
subacid1248473subacid
subadar10125583subadar
subah106015213suba__h
subahs114512383suba_hs
subalar9118073subalar
subarea939403subarea
subarid10310653subarid
subas74724073suba__s
subcool1146233subcool
subgum1136133sub_gum
subitems1245493subitems
sublate9315363sublat_e
sublated11311503sublated
sublates10315003sublates
sublation11311013sublation
sublot82315523sub_lot
sublots92410913sublots
subplot1158133subplot
subtask1335713subtask
subtaxa1644483subtaxa
subtaxon1742743subtaxon
subtle82113433sub_tle
subtly11249263sub_tly
subtone9310343sub_tone
sudation9310803sudation
sudatory1245843sudatory
suitor63311053su_itor
sunbath1236423sunbat_h
sunbathe1344033sunbathe
sunbaths1344383sunbaths
sunroom947013sunroom
superatom1348913superatom
symptom1644003symptom
tubate82813173tubat_e

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 Filter1786911340270.466383457.1
2DLD Change Limit134027708.45315855.6
3Display Results70700.0164375.0
 (SQL Overall)178691708.93519999.0
 
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.