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

102 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
portables133787(None) 
portable12313201portable_
potables12179701po_tables
notables10178242no_tables
parables121613562par_ables
portably1539312portabl_y
portages112613222porta_ges
portaled11239202porta_led
portals94015562porta_l_s
portances1349832portances
portholes14410372portholes
potable112115362po_table_
probables1545422probables
sortable10312482sortable_
worktables1942612worktables
arables91814973_ar_ables
boatable121610263boatable_
bootable12179223bootable_
burnables1344003burnables
cartable121314093cartable_
constables1446733constables
coracles121811163cor_acles
deportable1545653deportable_
durables11237013dur_ables
eatables10169793_eatables
exportable2144603exportable_
fordable1439593fordable_
formable1539503formable_
giftables1572593giftables
gustables12165223gustables
horribles14113973horribles
importable1646553importable_
morales93619403mor_a_les
mortals93914003morta_l_s
mortarless1243103mortarless
movables15175573mo_vables
moveables16163963moveables
notable92114903no_table_
oracles93212423_or_acles
outfables1485563_outfables
parable111819773par_able_
parsable12311693parsable_
partakes1449923parta_kes
partible1238063partible_
particles1339803particles
payables15166483p_ayables
pentacles1338773pentacles
percales12313803perca_les
petrales10312963petra_les
pettable121710713pettable_
pointable1337343pointable_
pokable15209503po_kable_
porbeagles1561673porbeagles
portabella1452273portabella
portabellas1552103portabellas
portabello1452093portabello
portabellos15101873portabellos
portage103013643porta_ge_
portaged12228463porta_ged
portal84218463porta_l__
portance12310113portance_
portapaks1742133portapaks
porthole1349523porthole_
porticoes1348253porticoes
portieres1138203portieres
portless10310643port__less
posable112212783po_sable_
postages112815323posta_ges
postals93716373posta_l_s
postholes14410453postholes
potages102416423po_ta_ges
potashes1337823po_tashes
potatoes1039943po_tatoes
potholes13312933po_tholes
pottages112910453potta_ges
pottles93816983po_t_tles
pourable1239133pourable_
prattles10189403p_rattles
preambles1545333p_reambles
probable1439053probable_
protases102115033prota_ses
protyles13249833prot_yles
provable1539093provable_
ratables10159723_ratables
reportable1446953reportable_
restables111511423restables
retables101712673_retables
sociables1344963sociables
sorbable1239303sorbable_
sortably1338803sortabl_y
sparables13167153spar_ables
spottable1345343spottable_
stables93219073__stables
storables1146283stor_ables
tables84524883___tables
totable92313363to_table_
turntables1242263turntables
variables1444673variables
vocables15145733vo_cables
votable122111373vo_table_
workable1737093workable_
worktable1844723worktable_

Search took 7 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411026.70322175.3
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.90625874.7
 
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.