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

163 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
caballed133716(None) 
canalled1139571canalled
balled94926892__balled
caballero1342882caballero
cabled114819872cab__led
called94126732c__alled
camailed1336552camailed
canaled103615552cana_led
canaller1038952canaller
carolled1138822carolled
catcalled1444892catcalled
cavilled1436732cavilled
gabelled12317582gabelled
labelled11278292labelled
abased96514993_aba_sed
abashed1357663_abashed
abated95918453_aba_ted
ablated102513443_ablated
abled86926833_ab__led
appalled1344813appalled
availed1135973_availed
babbled113612863bab_bled
bailed94726653__bailed
balded105417513__balded
baled85436443__ba_led
balked135219413__balked
ballad94315323__ballad
baller83825203__baller
ballet84733973__ballet
bawled124415693__bawled
begalled1236023begalled
belled94626183__belled
billed94224903__billed
bolled94722653__bolled
bulled94626493__bulled
cabal95222153caba_l__
cabala103516913caba_l_a
cabalas113516003caba_las
cabalism14310143cabalism
cabalist12314493cabalist
caballeros1442033caballeros
caballing1436883caballing
cabals104020153caba_l_s
cabaret112519043caba_ret
cabbaged1644383cabbaged
cabbed135416263cab__bed
cabined1239993cab_ined
cable95329913cab__le_
cabler104519173cab__ler
cables104527553cab__les
cablet104429463cab__let
caboched1844043caboched
caboshed1634393caboshed
cackled164613293ca_ckled
cadelle1039923cadelle_
cadelles1139973cadelles
cajoled17428273ca_joled
calked134617403c__alked
callee84327293c__allee
caller85125483c__aller
callet84536763c__allet
calmed114816383c__almed
calved125215453c__alved
canaille1048413canaille_
canailles1148273canailles
canalised12810913canalised
canalized21611693canalized
canallers1137213canallers
canceled13279393canceled
cancelled1456743cancelled
candled113815733ca_ndled
capable13313363capable_
capabler1435353capabler
capsuled1334533capsuled
caracoled1445983caracoled
caracolled1543013caracolled
caroled103717683ca_roled
caroller1039203caroller
castled104311513ca_stled
cataloes10311653cataloes
cataloged1365303cataloged
catalyzed2444993catalyzed
catcaller1344813catcaller
caulked14486673ca_ulked
cavalier1348173cavalier
cavalla1257883cavall_a
cavallas1366843cavallas
cavallies1446393cavallies
cavally1588483cavall_y
caviled1348723ca_viled
caviller1337063caviller
celled94420323c__elled
chalked17449863c_halked
chilled133310933c_hilled
coaled95022703c_oa_led
cobbled143411633cob_bled
corbelled1446613corbelled
corralled1245283corralled
craaled10339423c_raaled
cradled113410813c_radled
crawled133710393c_rawled
culled94022473c__ulled
cupelled1365743cupelled
dabbled133712073dab_bled
dialled9510133_dialled
embalmed1544263embalmed
equalled1834863equalled
eyeballed1542233eyeballed
fabled124216383fab__led
gabbled134112453gab_bled
gabelle10259213gabelle_
gabelles11278933gabelles
gabled105518453gab__led
galled84622863__galled
gambolled1543103gambolled
gavelled13387363gavelled
gimballed1542673gimballed
imbalmed1543293imbalmed
inwalled1275773inwalled
labeled102510563lab_eled
labeller10248073labeller
lalled74218753__lalled
lapelled11227083lapelled
libelled11317213libelled
lowballed1542053lowballed
malled94626113__malled
manacled1336453manacled
medalled1246893medalled
metalled1148983metalled
muralled1136423muralled
napalmed1342503napalmed
palled94625163__palled
panelled1138963panelled
parallel1047463parallel
pedalled1246923pedalled
petalled1138693petalled
pinballed1444033pinballed
rabbled123514423rab_bled
ravelled12419783ravelled
rebelled113110323rebelled
rebilled11318053rebilled
recalled11310803recalled
rivalled1236093rivalled
sandalled1145903sandalled
scabbled15156303scab_bled
scandalled1443073scandalled
sepalled1156903sepalled
spalled103113123_spalled
squalled1835943squalled
stalled83515683_stalled
tabarded1234743tabarded
tabled94020043tab__led
thralled1245803thralled
totalled935843totalled
umbelled1336273umbelled
unbaled103315963unba_led
unbilled1188693unbilled
uncalled11810923uncalled
ungalled1078463ungalled
unwalled1288653unwalled
vialled1156843_vialled
wabbled153311443wab_bled
walled104021293__walled

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 Filter1786911461620.266671770.7
2DLD Change Limit1461621638.31317582.3
3Display Results1631630.0632587.3
 (SQL Overall)1786911638.64220677.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.