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

123 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
dragsters113433(None) 
dragster1034631dragster_
dabsters1137052d_absters
diasters92913182dia_sters
drafters12338532dra_fters
draggers11357392drag_gers
gagsters10317082_gagsters
rasters74629022_ra_sters
arresters948193arresters
asters65631603__a_sters
basters94930303_ba_sters
blasters104116143bla_sters
boasters103915663boa_sters
braggers12327903brag_gers
brasiers103710513bra_siers
casters94729903_ca_sters
coasters104317343coa_sters
crafters13419953cra_fters
crashers134013233cra_shers
craters95021893cra__ters
dabster1036703d_abster_
daggers103714913d_ag_gers
darters84017603d_a_rters
dashers115016863d_a_shers
daters74827373d_a__ters
daughters1443993daughters
daunters9329853d_aunters
daystars1243903d_aystars
deemsters1285023deemsters
degassers11354833degassers
delusters1035983delusters
demisters1249203demisters
dempsters1435273dempsters
detesters10298303detesters
diameters1247603diameters
diastems11226523dia_stems
diaster82813313dia_ster_
diesters92513603d_iesters
digesters11257883digesters
disasters1039153disasters
doomsters1236173doomsters
dopesters1237283dopesters
draftees12225253dra_ftees
drafter11449433dra_fter_
dragees9359483drag__ees
dragger10309173drag_ger_
draggier11135773draggier_
draggles1145963draggle_s
dragnets10136563drag_nets
dragonets11134503dragonets
dragstrip1351543dragstrip
dragstrips1451383dragstrips
drainers92811253dra_iners
drapers105313353dra__pers
drawers113610073dra__wers
drawlers12307313dra_wlers
dressers9359863dr_essers
drifters12417913dr_ifters
drugstore1142503drugstore
drugstores1252103drugstores
dumpsters1453743dumpsters
dusters84918363d__usters
easters75125683_ea_sters
erasers74413943era_s_ers
fagoters1234863_fagoters
feasters11511563fea_sters
fraters103517213fra__ters
fraudsters1441913fraudsters
gagster9317633_gagster_
gangsters11205733gangsters
gasters85624293_ga_sters
grafters12409193gra_fters
granters93614143gra_nters
graspers11338403gra_spers
graters85419743gra__ters
gristers94013413gr_isters
hamsters13710423_hamsters
kraters114212343kra__ters
lamsters1099753_lamsters
lasters75627693_la_sters
magisters1235803_magisters
masters94628923_ma_sters
pasters94531733_pa_sters
piasters102912813pia_sters
plaisters1137813plaisters
plasters103518133pla_sters
praisers103410833prais_ers
pranksters1653283pranksters
praters94921653pra__ters
presters103419003pr_esters
rafters103715633_ra_fters
raisers73617393_rais_ers
ranters73323643_ra_nters
rasers64526783_ra_s_ers
rashers104020913_ra_shers
raspers94415923_ra_spers
raster64731443_ra_ster_
raters63936583_ra__ters
ratters74422473_ra_tters
registers1038893_registers
resters74130403_r_esters
righters122610713_righters
roadsters1035103roadsters
roasters83615933_roasters
roisters83615563_roisters
roosters83514673_roosters
rosters73727553_r_osters
rousters84315683_rousters
roysters113610533_roysters
scamsters1334993scamsters
seamsters1136333seamsters
songsters1046113songsters
tapsters10318803_tapsters
tasters74225643_ta_sters
teamsters1135973teamsters
toasters83912723toa_sters
transfers1238053transfers
trashers113013643tra_shers
trusters83112263tr_usters
trysters11298373tr_ysters
waisters113811523_waisters
wasters104026593_wa_sters
wresters112711733wr_esters

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411237.36020195.8
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.85922737.1
 
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.