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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
latticed113479(None) 
lattice938431lattice_
lattices1038381lattices
attired8238912_attired
bratticed1443282bratticed
latices9313762la_tices
anticked1538393_anticked
antired82316193_antired
articled1137063_articled
attached14165703_attached
attacked15125113_attacked
attained997353_attained
attic75618353_attic__
atticized2146143_atticized
attics84413283_attic_s
attire62412383_attire_
attires72312953_attires
attrited947373_attrited
attuned835173_attuned
baptised1335263baptised
baptized2245483baptized
batiked1435963ba_tiked
batted95623653batt__ed
battened11259573battened
battered113315053battered
battier93515713batti_er
battled104213123batt_led
blatted104812713blatt__ed
blattered12198563blattered
brattice1245693brattice_
brattices1345553brattices
catted95422473catt__ed
cattie85221023catti_e_
cattier93317073catti_er
catties94023053catti_es
clattered12178403clattered
enticed101411193_enticed
fatted105419843fatt__ed
fattened12268283fattened
fattier103513463fatti_er
fatties103018203fatti_es
flatlined13275003flatlined
flatted114012943flatt__ed
flattened13185303flattened
flattered13188623flattered
hatted104921513hatt__ed
jettied15366973jetti_ed
juttied15417863jutti_ed
laced87132643la___ced
lactated1138863lactated
lactic10713493lactic__
laicised1145643laicised
laicized2046043laicized
laired75216813la__ired
laities7320343laiti_es
lanced93717723la__nced
lasted74323603last__ed
latched133914063la_tched
lated65240673la_t__ed
latened8711923la_tened
laterized1979903laterized
lathed104718453la_t_hed
lathered121512323lathered
lathier10310833lathi_er
latinized1988533latinized
latitude9185513latitude
latrine7715123latrine_
latrines8515003latrines
latte55426303latt__e_
latten65018203latt__en
latter65027893latt__er
lattes65324203latt__es
latticing1246063latticing
lattin64316223latti__n
lattins74115483latti_ns
lazied164610653la_zi_ed
lenticel1066123lenticel
letted74118543lett__ed
lettered92910783lettered
lettuce943323lettuce_
lettuces1043503lettuces
littered92511383littered
lotted74222403lott__ed
matrices12312083matrices
matted94521413matt__ed
mattered112412903mattered
morticed1377163morticed
nattered92011623nattered
nattier73614623natti_er
noticed1037863_noticed
pantiled113111593pantiled
partied103516553parti_ed
patined105114783pa_tined
patted94724683patt__ed
pattened11299393pattened
pattered112714203pattered
pattie84020963patti_e_
patties93425143patti_es
platted103614263platt__ed
practiced1655113practiced
puttied103811163putti_ed
rattailed1084213rattailed
ratted74923343ratt__ed
rattened9218623rattened
rattier74015593ratti_er
rattled84012953ratt_led
slatted84015183slatt__ed
statice92614033statice_
statices102712343statices
tatted74920533tatt__ed
tattered92011443tattered
tattie64817513tatti_e_
tattier74216243tatti_er
tatties74120343tatti_es
tattled84311483tatt_led
tattooed944573tattooed
triced95518673__triced
unattired1045083unattired
vatted104214733vatt__ed
wattled113610503watt_led
yattered12239533yattered

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621217.48319532.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.68523251.9
 
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.