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

211 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
scottie93746(None) 
scotties1039751scotties
cattie85221022_cattie
cootie84223092_cootie
cottae84615702_cottae
cottier93814172_cottier
hottie92514382_hottie
scattier10267582scattier
scotia8310802sco_tia
scuttle936462scuttle
shortie10411342shortie
snottier8217382snottier
softie93312482s_oftie
sortie63621992s_ortie
spottier10207312spottier
aconite9315473aconite
biotite9311033biotite
biscotti1243333biscotti_
blottier10336413blottier
bootie85421163_bootie
bottle84916073_bottle
cattier93317073_cattier
catties94023053_catties
cattle85118903_cattle
coatee84327223_coatee
coati75624643_coati_
coatis85122603_coatis
cocotte1138603cocott_e
collie83621993_collie
commie124215523_commie
comte96125473_comt_e
conte76633203_cont_e
cookie123716043_cookie
coolie83821603_coolie
coontie9311423coontie
cooties93725733_cooties
corbie103618203_corbie
corrie83621233_corrie
cortin82423153_cortin
cosie74728263_co_sie
costae85319683_costae
costive12312843_costive
cote66648733_co_t_e
coterie9417403_coterie
cotta75818573_cott_a
cottage104210573_cottage
cottar84613813_cottar
cottas84615573_cottas
cotter84926673_cotter
cottiers10399153_cottiers
cotton8312993_cotton
cotype1346823_cotype
couthie121810553_couthie
cowpie133511513_cowpie
cowrie113814283_cowrie
cozie163519133_co_zie
cutie76925933_c_utie
cutties93118843_cutties
cuttle84113893_cuttle
dhootie1136473dhootie
dottier83910923_dottier
dottle74212503_dottle
ecotage1036883ecotage
ecotone938583ecotone
ecotype1444843ecotype
footie94718143_footie
footsie1047653footsie
glottic1036653glottic
glottis837173glottis
grottier9316673grottier
hogtie102711773_hogtie
hotties103016963_hotties
knottier12203983knottier
lotte54923853_lott_e
motte75526973_mott_e
mottle84116053_mottle
pattie84020963_pattie
plottier10327263plottier
plotties103111413plotties
postie84123963_postie
potpie103412433_potpie
potsie83916033_potsie
pottier93516493_pottier
potties93723543_potties
pottle84416103_pottle
prostie91617743prostie
puttie84116303_puttie
rotte54625933_rott_e
saltie63422433s_altie
scantier10309983scantier
scanties103215423scanties
scathe114414993sc_athe
scatt76030093scatt__
scatted103512773scatted
scatter93815173scatter
scattiest11268373scattiest
scatting113311813scatting
scatts85914663scatt_s
scatty115310653scatt_y
sceptic1337833sceptic
sceptre1135053sceptre
schtik15185423sc_htik
sciatic11910173sciatic
sconce104711723sco_nce
scone74621833sco__ne
scoot75729153scoot__
scootch1434463scootch
scooted103612283scooted
scooter93312873scooter
scooting113012643scooting
scoots85315943scoot_s
scope94821483sco__pe
score75526743sco__re
scoria8513503sco_ria
scoriae9310903scoriae
scot66242613sco_t__
scotch13207523sco_tch
scotched16187933scotched
scotches15179473scotches
scoter83815483sco_ter
scoters93313813scoters
scotias939753scotias
scotoma1155963scotoma
scotopia1245733scotopia
scotopic1446513scotopic
scots74025913sco_t_s
scourge1035653scourge
scouse84113633sco_use
scout75031453scout__
scouted104112033scouted
scouter93313323scouter
scouth115011153scout_h
scouther1356943scouther
scouths12527893scouths
scouting112612753scouting
scouts84817943scout_s
scrapie115010943scrapie
scutage1036333scutage
scutate9310323scutate
scute75520943sc_ut_e
scutter93512173scutter
scuttled1134533scuttled
scuttles1056503scuttles
scythe14466013sc_ythe
settee63721023s_ettee
settle63915663s_ettle
sheltie10109913sheltie
shittier1137313shittier
shittim1245133shittim
shortia1048193shortia
shorties11414583shorties
shote85526103sho_t_e
shott85332193shott__
shotted113912403shotted
shotten10288463shotten
shotting123012383shotting
shotts93614703shott_s
showtime1643773showtime
shuttle1046103shuttle
skittle1135533skittle
slittier837003slittier
slotted84613883slotted
slotter73314453slotter
slotting92612613slotting
sluttier836453sluttier
smartie9310173smartie
smoothie1344893smoothie
smote75820283smo_t_e
smuttier1035213smuttier
snootier8278383snootier
snottiest9167973snottiest
snottily1145553snottily
snotty9489203snott_y
snoutier8206973snoutier
softies103414613s_ofties
somite84519373s_omite
sonsie6614863s_onsie
soothe94214853s_oothe
sootier73916613s_ootier
sopite84917713s_opite
sortied83314103s_ortied
sorties74126403s_orties
sotted74121403s_otted
sottish10129443s_ottish
spittle937923spittle
sportier102010053sportier
sportif1238803sportif
sportive1348333sportive
spotlit947303spotlit
spotted103713143spotted
spotter94514883spotter
spottiest11177693spottiest
spottily1335153spottily
spotting112812093spotting
spotty11448583spott_y
stogie7311323sto_gie
stoolie739723stoolie
stotin63215063sto_tin
stott56929793stott__
stotted83511423stotted
stotting92811163stotting
stotts64612863stott_s
stourie7469353stourie
suttee63721543s_uttee
sweetie10157873sweetie
swotted11398713swotted
swotter10399473swotter
swotting12268483swotting
tattie64817513_tattie
tittie63213153_tittie
tootsie737133tootsie

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272116.89319443.9
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.35924282.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.