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

103 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
sortably133880(None) 
portably1539311portably
sortable10312481sortable
formably1846662formably
mortally1339932mortally
notably12199992no_tably
portable12313202portable
sociably1546792sociably
sorbable1239302sorbable
stably113314122s__tably
suitably1347592suitably
workably2044742workably
adorably1446443ador_ably
aortal65217513aorta_l_
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
coitally1339483coitally
costally1339733costally
countably1646293countably
curably142010773cur_ably
dorsally1246833dorsally
drably123511613_dr_ably
durably13229053dur_ably
forcibly1843863forcibly
fordable1439593fordable
formable1539503formable
formally1638243formally
heritably1746813heritably
horribly16114313horribly
irritably1446033irritably
lovably15187063lo_vably
loveably16175233loveably
morally12411493mor_ally
mortal84616853morta_l_
mortals93914013morta_ls
mortary12369043morta_ry
movably17167043mo_vably
moveably18175543moveably
mutably1438613_mutably
normally1347883normally
notable92114903no_table
orally93113593_or_ally
portables1337873portables
portal84218463porta_l_
portals94015563porta_ls
portly114713403port__ly
postally13310273postally
potable112115363po_table
probably1746413probably
provably1846213provably
quotably2244153quotably
ratably121711513_ratably
salably121610743s_alably
saleably1338213saleably
salvably1645443salvably
satiably1337823satiably
scalably15166703scalably
scrabbly17164623scrabbly
scrawly15197193scr_awly
scribbly17143623scribbly
scrutable1346043scrutable
serially11912843serially
servable13310093servable
shamably18165803shamably
shortly13387573short__ly
sizably2136613s_izably
sizeably2244683sizeably
sociable1239503sociable
socially1338543socially
softball1344203softball
softly12457763soft__ly
solubly1255283so_lubly
solvable1337473solvable
soothly13186923soot_hly
sootily101810523soot_ily
sordidly1344663sordidly
sorely94618013sor__ely
sororally1246393sororally
sorrily1039833sor_rily
sorta57125413sorta___
sottedly1244303sottedly
sovranly1443453sovranly
sowable121610753so_wable
sportily1337733sport_ily
spottable1345343spottable
sprawly15166043spr_awly
stable83921643s__table
statable10310703statable
storable10310733stor_able
suably112814533s__uably
suitable10310893suitable
surfable1338443surfable
totable92313363to_table
totally1039893to_tally
unstably1339493unstably
variably1637433variably
veritably1746543veritably
vocably17157153vo_cably
votable122111373vo_table
workable1737093workable
worktable1844723worktable
worthily1745253worthily

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.436409841.7
2DLD Change Limit1461621038.28317646.0
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.76520386.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.