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

140 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
sustains83855(None) 
sustain738771sustain_
abstains1047322abstains
curtains10259702curtains
destains9311812destains
distains9413602distains
dustbins1144592dustbins
fusains1038362fus_ains
fustians1146402fustians
sextains15246812sextains
stains64923652__stains
sultans72411832sulta_ns
suntans72111732sunta_ns
sustained1045382sustained
sustainer944782sustainer
sustainers1044132sustainers
abstain947253abstain_
attains7310983_attains
buskins133310943bus_kins
bustards11308513bustards
bustics11810883bust_ics
busting104221793bust_ing
bustline10208843bustline
bustlines11207353bustlines
bustling112110063bustling
captains121810573captains
contains10316533contains
curtails10318243curtails
curtain9319793curtain_
custards11338393custards
cutins83919983cu_t_ins
cysteins1355733cysteins
destain8412083destain_
detains83716093_detains
disdains1037913disdains
distain8313783distain_
distrains10411333distrains
dustbin1044543dustbin_
dusting93618993dust_ing
dustings10419033dust_ings
dustpans1143233dustpans
estrins7315853_estrins
eustacies1146603eustacies
eustasies946023eustasies
fountains1245283fountains
fusain958643fus_ain_
fustian1036903fustian_
fustics1279593fust_ics
gastrins9310123gastrins
gustations1147233gustations
gusting93917163gust_ing
histamins1476723histamins
hustings12378683hust_ings
hustling12228793hustling
isatins7310773_isatins
justing153615163just_ing
justling16207253justling
lusting83619323lust_ing
lustring9269723lustring
lustrings10245553lustrings
luteins7310103lu_teins
mistrains11511353mistrains
mountains1146363mountains
muntins92715133munt_ins
murrains1036853murrains
muslins9312213mus_lins
mustang10267933musta_ng
mustangs11255973mustangs
mustards11297883mustards
musting103221073must_ing
nystatins1244753nystatins
obtains939163_obtains
oestrins8312673oestrins
ouabains1044363ouabains
ousting84021353oust_ing
outgains9810163outgains
outsails8139863outsails
outsins73417863ou_tsins
pertains102113423pertains
postins93721203post_ins
pushpins1543343pushpins
quatrains1845583quatrains
quintains18306033quintains
restrains9311623restrains
retains74522253_retains
rustics9810733rust_ics
rusting83821263rust_ing
rustling9249983rustling
rutins63818393ru_t_ins
sains55639973__s_ains
sasins64923103sas__ins
satins64930483s_at_ins
seatrains947603seatrains
seitans73312303seita_ns
sestina72711973sest_ina
sestinas8249133sest_inas
sestine73017923sest_ine
sestines82717243sest_ines
sextain14257103sextain_
sextans14349263sexta_ns
siskins1159583sis_kins
sprains93013593s_prains
staigs75414813__staigs
stain55727943__stain_
stairs65416333__stairs
statins73719773__statins
steins64818343__steins
stotins73213873stot_ins
strains74218153s_trains
subbasins1344763subbasins
suberins10315093suberins
subjoins1745453subjoins
substages12127353substages
substates111410333substates
substations1348243substations
subtasks1444493subtasks
subtaxons1842683subtaxons
subteens1037423subteens
subtilins1147173subtilins
suctions103012903suctions
sudations1039903sudations
suiting83419003suit_ing
suitings9288953suit_ings
suldans8299723sulda_ns
sultan63012593sulta_n_
sultana7257803sulta_na
sultanas8237153sultanas
sultanic1046173sultanic
suntan62613003sunta_n_
surtaxes1536513surtaxes
surtaxing1784143surtaxing
sushis9311183sus_hi_s
susliks1136443sus_liks
sussing84013703sus_sing
sustaining1145883sustaining
suttas63813793sutta__s
suzerains1845733suzerains
swains94513953__swains
tains54936323___tains
upstairs1043643upstairs

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621406.97020970.2
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.43924020.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.