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

144 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
sustain73876(None) 
sustains838551sustains
abstain947252abstain
curtain9319792curtain
destain8412082destain
distain8313782distain
dustbin1044542dustbin
fusain958642fus_ain
fustian1036902fustian
sextain14257092sextain
stain55727932__stain
sultan63012592sulta_n
suntan62613002sunta_n
sustained1045372sustained
sustainer944782sustainer
abstains1047323abstains
attain6311753_attain
buskin123811493bus_kin
busman10310253busma_n
bustard10389723bustard
bustic101012693bust_ic
busting104221793bust_ing
bustline10208843bustline
bustling112110063bustling
captain112111053captain
certain92612213certain
contain9315823contain
curtail9299663curtail
curtains10259703curtains
custard10389973custard
cutin75022773cu_t_in
cystein1246053cystein
destains9311813destains
detain74617383_detain
disdain938513disdain
distains9413603distains
distrain9412243distrain
dustbins1144593dustbins
dusting93618993dust_ing
dustman1044683dustman
dustmen1035773dustmen
dustpan1043243dustpan
estrin6315923_estrin
eustacy1254663eustacy
eustasy1043873eustasy
eustatic1047343eustatic
fountain1144923fountain
fusains1038363fus_ains
fustians1146403fustians
fustic11910633fust_ic
gastrin839823gastrin
gustation1047963gustation
gusting93917163gust_ing
histamin1387023histamin
hustling12228793hustling
isatin6412213_isatin
justing153615163just_ing
justling16207253justling
lusting83619323lust_ing
lustring9269723lustring
lutein6311263lu_tein
mislain9311243mislain
mistrain10311943mistrain
mountain1046113mountain
muntin82915183munt_in
murrain937753murrain
muslin8312213mus_lin
mustang10267933mustang
mustard10359533mustard
musting103221073must_ing
nystatin1145093nystatin
obtain839183_obtain
oestrin7312233oestrin
ouabain944943ouabain
ousting84021353oust_ing
outgain81010743outgain
outlain71212613outlain
outsaid81210923outsaid
outsail71411413outsail
outsin63617553ou_tsin
pertain92714963pertain
postin83521033post_in
pushpin1443233pushpin
quatrain1745823quatrain
quintain17316213quintain
restrain8311703restrain
retain64523283_retain
rustic8712673rust_ic
rusting83821263rust_ing
rustling9249983rustling
rutin55421343ru_t_in
sain45551293__s_ain
sasin54626573sas__in
satin55935213s_at_in
seatrain847923seatrain
seitan62613233seita_n
sestina72711973sest_ina
sestine73017923sest_ine
sextains15246813sextains
sextan13389643sexta_n
siskin1079783sis_kin
slain54923573__slain
sprain83614863s_prain
staid66722073__staid
staig65519633__staig
stains64923653__stains
stair54719933__stair
statin63921463__statin
stein54620533__stein
stotin63215043stot_in
strain64919573s_train
subbasin1245393subbasin
suberin9314563suberin
subjoin1645443subjoin
substage11117183substage
substate101711083substate
substation1248983substation
subtask1335713subtask
subtaxa1644483subtaxa
subtaxon1742743subtaxon
subteen938523subteen
subtilin1047113subtilin
suction93713043suction
sudation9310803sudation
suiting83419003suit_ing
suldan72611043sulda_n
sultana7257803sultana
sultanic1046173sultanic
sultans72411833sultans
suntans72111733suntans
surtax1337843surta_x
surtaxing1784143surtaxing
sushi8310493sus_hi_
sushis9311183sus_his
suslik1036373sus_lik
sussing84013703sus_sing
sustainers1044123sustainers
sustaining1145883sustaining
sutta54015333sutta__
suttas63813793sutta_s
suzerain1745763suzerain
swain84919053__swain
tain45548073___tain
upstair943983upstair

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271447.84617082.2
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.06222164.6
 
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.