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

110 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
tallboy126514(None) 
callboy1465831callboy
tallboys1374621tallboys
alloy85519972_all_oy
bellboy1445122bellboy
callboys1585182callboys
tallol63612222tall_ol
tallow93714202tall_ow
tallowy13347632tallowy
tally84526862tall__y
allay85620393_all_ay
alley85721673_all_ey
allod64418383_all_od
allot54933873_all_ot
allow85420663_all_ow
alloys94014563_all_oys
ally76935643_all__y
attaboy1264303attaboy
balboa10389963ba_lboa
ballon84117493ball_on
balloon93711433balloon
ballot84624093ball_ot
ballsy11508873ball_sy
bally105530103ball__y
batboy1387533ba_tboy
bellboys1544523bellboys
bullyboy1842423bullyboy
callow114714663call_ow
carboy134914183ca_rboy
dally95324743dall__y
fallacy1536433fallacy
fallibly1644393fallibly
fallow124713853fall_ow
flyboy17113913_flyboy
galleon8278713galleon
gallery11468743gallery
galley104215453gall_ey
gallfly1433523gallfly
galliot82214133galliot
gallon73715813gall_on
galloon82910643galloon
galloot82814223galloot
gallop93311383gall_op
gally95026173gall__y
hallo85127553hall_o_
halloa94918123hall_oa
halloo95118973hall_oo
halloos103716743halloos
hallos95425103hall_os
hallot95426783hall_ot
hallow124818323hall_ow
hallway1636173hallway
hautboy1553423hautboy
hellbox1944993hellbox
killjoy2142343killjoy
mailbox1853563mailbox
mallow114014743mall_ow
pageboy1543873pageboy
pallor8313673pall_or
pally105727123pall__y
pillbox1843413pillbox
playboy1743813playboy
rally84725903rall__y
salably121610743salably
sallow94315753sall_ow
sallowy13369343sallowy
sally85129713sall__y
saltbox1643743saltbox
stableboy1651743stableboy
stallion837523stallion
tabby125213893ta__bby
taboo73418093ta__boo
tabor75518393ta__bor
tailbone1045493tailbone
tailor63412503tail_or
talcky15294723ta_lcky
talion6317713ta_lion
talipot949723talipot
talky126215683ta_l_ky
tall47240213tall___
tallage82712073tallage
taller63721963tall_er
tallest7317093tallest
tallied83314753tallied
tallier72817213tallier
tallies73624603tallies
tallis63319963tall_is
tallish103313583tallish
tallit63422733tall_it
tallith102913063tallith
tallits73215993tallits
tallols73311363tallols
tallows103313743tallows
talls55133433tall__s
tallyho1343043tallyho
tallyhos1443333tallyhos
talon55824113ta_l_on
tannoy958363ta_nnoy
taxably1936043taxably
telly84920823tell__y
tollbar945453tollbar
tollway1344793tollway
tomboy1358213t_omboy
toolbox1653633toolbox
trilby1144973trilb_y
valley124311603vall_ey
wallaby1535073wallaby
wallop113310293wall_op
wallow123913513wall_ow
wally114625093wall__y

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271109.27014458.1
3Display Results1101100.0303666.7
 (SQL Overall)1786911109.72018383.8
 
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.