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

142 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
facetted144574(None) 
faceted13509561face_ted
abetted1058322_abetted
acetated112010682_acetated
facete115014832face_te_
fatted105419842fa__tted
fetted104817892f__etted
fretted113411852f_retted
gazetted19234852gazetted
abetter958323_abetter
abutted1056983_abutted
accented13107773accented
accepted15105373accepted
acerated113113983_acerated
acetate92514753_acetate_
acetates102013063_acetates
acted88521733_ac__ted
affected1744793affected
agented939423_agented
alerted82512223_alerted
averted112211613_averted
baccated15148373baccated
bassetted1244693bassetted
batted95623653ba__tted
betted94721163__betted
cacheted16148233cacheted
caseated11310713caseated
casette9310393casette_
casettes1039653casettes
catted95422473__catted
caveated1439133caveated
curetted1137173curetted
duetted937023_duetted
excepted2055233excepted
faced117727653fac___ed
facelifted1952173facelifted
facet106038523face_t__
facetely1643853facetely
facetiae1346213facetiae
faceting1438783faceting
facets116316653face_t_s
facetting1535283facetting
factoid1338693fac_toid
factored1436213factored
faggoted1443103faggoted
fagoted1236073fa_goted
fainted114211723fa_inted
faithed1437163fa_ithed
falcated1438473falcated
faltered122810983faltered
farted105121783fa__rted
fasciated1546133fasciated
fasted105320953fa__sted
fastened12257853fastened
fated95632133fa___ted
fatten94314903fa__tten
fattened12268283fattened
fatter94523213fa__tter
faulted11227723fa_ulted
felted103714653f__elted
feted94420933f__e_ted
fetter94120383f__etter
fettled11378933f__ettled
fileted1159093file_ted
fitted104716663f__itted
flatted114012943f_latted
fleeted113310233f_leeted
flitted114011643f_litted
fomented1437803fomented
forested12312463forested
fouette1038213fouette_
fouettes1137883fouettes
foveated1536293foveated
fracted1339373frac__ted
fretter103412753f_retter
fritted113611333f_ritted
fumette1245523fumette_
fumettes1345773fumettes
galeated104111573galeated
galette84212693galette_
galettes93111153galettes
garotted1066193garotted
gavotted1363343gavotted
gazette17357363gazette_
gazettes18296863gazettes
hatted104921513ha__tted
incented112412543incented
incepted13177773incepted
insetted9249023insetted
jacketed22146533jacketed
jetted143915083__jetted
lacerated122210673lacerated
lacertid1146383lacertid
lactated1138863lactated
lamented1138193lamented
lanceted1137073lance_ted
layette1037133layette_
layettes1136263layettes
letted74118543__letted
macerated142010523macerated
matted94521413ma__tted
navette1036983navette_
navettes1136613navettes
netted74118713__netted
packeted17148283packeted
palette93613983palette_
palettes103112833palettes
parented11912213parented
pargetted1345663pargetted
patented1188893patented
patted94724683pa__tted
petted94121523__petted
pipetted1335263pipetted
racemed1237013race_med
racheted14149503racheted
racketed15169123racketed
raclette1047643raclette_
raclettes1147013raclettes
ratted74923343ra__tted
retted74826313__retted
revetted122210943revetted
rewetted12228353rewetted
rivetted12226083rivetted
sacheted14127833sacheted
safetied1244663safetied
scatted103512773_scatted
scented102811883_scented
stetted82610403_stetted
tabletted1244833tabletted
talented938423talented
tatted74920533ta__tted
unabetted1244993unabetted
unletted9310313unletted
unwetted1238123unwetted
vacated1349353vac_ated
valeted1139013vale_ted
vatted104214733va__tted
vetted104316323__vetted
wadsetted1442623wadsetted
wetted103717023__wetted
whetted14256693_whetted
yachted1634853yac_hted

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621426.50322476.1
3Display Results1421420.0602366.7
 (SQL Overall)1786911426.73326539.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.