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

146 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
totalled93584(None) 
totaled839691tota_led
metalled1148982metalled
petalled1138702petalled
retotalled1143622retotalled
stalled83515682_stalled
thralled1245802thralled
tolled73819032to__lled
tomalley1343282tomalley
totable92313362totable_
totalised1048072totalised
totalized1949452totalized
totally1039892totall_y
towelled1236352towelled
appalled1344813appalled
balled94926893__balled
begalled1236023begalled
bobtailed1443193bobtailed
bolled94722653bo__lled
bottled104611233bot_tled
bowelled1446173bowelled
caballed1337163caballed
called94126733__called
canalled1139583canalled
catcalled1444893catcalled
coaled95022713co_a_led
corralled1245283corralled
detailed10319873detailed
dialled9510133_dialled
dolled83518073do__lled
dowelled1356343dowelled
entailed989523entailed
equalled1834863equalled
extolled1654303extolled
foaled104515963fo_a_led
galled84622863__galled
goaled85014363go_a_led
hostelled1345703hostelled
hovelled15146843hovelled
installed1045843installed
inwalled1275773inwalled
lalled74218753__lalled
lolled74315823lo__lled
lowballed1542053lowballed
malled94626113__malled
medalled1246893medalled
metaled102913883meta_led
modelled1236433modelled
mothballed1851883mothballed
mottled10409973mot_tled
muralled1136423muralled
notable92114903notable_
notables10178243notables
notated82713663nota_ted
palled94625163__palled
pedalled1246933pedalled
petaled103614153peta_led
polled94022003po__lled
portaled11239203porta_led
potable112115363potable_
potables12179703potables
potholed1448393potholed
recalled11310803recalled
retailed94113963retailed
retallied1046783retallied
retotaled1045953retota_led
rivalled1236093rivalled
rolled74220243ro__lled
rotated82715293rota_ted
rototilled1152323rototilled
rowelled1236633rowelled
sepalled1156903sepalled
spalled103113133_spalled
squalled1835943squalled
stabled103514953_stabled
staled74728103_sta_led
stalked123811173_stalked
stapled103613703_stapled
stilled83314783_stilled
subtotalled1462033subtotalled
tabled94020043__tabled
tailed74424663__tailed
talced93811003__talced
talked114015403__talked
taller63721963__taller
tallied83314753__tallied
tattled84311483tat_tled
teazled17326833t_eazled
teetotalled1252053teetotalled
tentacled1244953tentacled
thrilled1235493thrilled
tilled74722953__tilled
titled73815003tit__led
toadied9248013to_adied
toasted84011923to_asted
toddled10328823to_ddled
toenailed1043483toenailed
togaed84711343toga__ed
togated94410663toga_ted
toggled10428653to_ggled
toiled74420323to__iled
toled65934923to___led
toller63819443to__ller
tomalleys1441673tomalleys
tonally10311373tonall_y
tooled74918903to__oled
tootled83511043to_otled
toppled12348843to_ppled
total55321823tota_l__
totaling9610303totaling
totalise8312503totalise
totalises9311783totalises
totalism10311093totalism
totalist8315583totalist
totality1139373totality
totalize17311523totalize
totalizer1847993totalizer
totalizes18311053totalizes
totalling1036523totalling
totals63115163tota_l_s
toteable1048353toteable_
toted64929483tot___ed
totted74319953tot__ted
tottered9208703tottered
tousled84710363to_usled
touzled17367153to_uzled
towable121910113towable_
toweled112410223to_weled
trailed83415673t_railed
trawled113411523t_rawled
treadled1067123treadled
trilled84116313t_rilled
trolled84312263t_rolled
trowelled1344443trowelled
twattled1273463twattled
twilled11398033t_willed
uncalled11810923uncalled
ungalled1078463ungalled
untilled9710563untilled
unwalled1288653unwalled
uptalked1533053uptalked
vialled1156843_vialled
votable122111373votable_
walled104021293__walled
woolled1136643wo_olled
yodelled1334603yodelled

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.423422437.4
2DLD Change Limit1461621467.42319690.4
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.89222642.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.