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 “abstains” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
abstains104732(None) 
abstain947251abstain_
abstained1245052abstained
abstainer1144402abstainer
abstainers1243452abstainers
attains7310982a_ttains
destains9311812destains
distains9413602distains
obtains939162ob_tains
stains64923652__stains
sustains838552sustains
abating10413973abat_ing
abatis84317933abat_i_s
abattis9297823abatti_s
abetting1158293abetting
abigails1143333abigails
ablating11311993ablating
ablations11311513ablations
ablins8316193ab__lins
abscisins1343593abscisins
abseils935973abs_eils
abstaining1344573abstaining
abstracts1346593abstracts
abstrict1257943abstrict
abstricts1355183abstricts
abutting1137003abutting
acetins9313173acet_ins
actins86321103a_ct_ins
arshins10312573ars_hins
assails769093a_ssails
assais6711963a_ssai_s
astasias8410143a_stasias
astatine8313533a_statine
astatines9310343a_statines
attain6311753a_ttain_
attaint7313473a_ttaint
attaints846493a_ttaints
bargains1178643bargains
basins85722763bas__ins
bastards113310313bastards
basting104227203bast_ing
bastings114214693bast_ings
bastions10411693bastions
betaine9413783_betaine
betaines10313293_betaines
blains84516373_b_lains
brains85125473_b_rains
cabstand1344413cabsta_nd
cabstands1453733cabstands
capstans1257243capsta_ns
captains121810573captains
contains10316533contains
curtains10259703curtains
cysteins1355733cysteins
destain8412083destain_
detains83716093_detains
disdains1037913disdains
distain8313783distain_
distrains10411333distrains
dustbins1144593dustbins
estrins7315853_estrins
fusains1038363fus_ains
fustians1146403fustians
gastrins9310123gastrins
habitans1346623habita_ns
histamins1476723histamins
isatins7310773_isatins
maintains1167103maintains
mistrains11511353mistrains
nystatins1244753nystatins
obtain839183ob_tain_
oestrins8312673oestrins
pertains102113423pertains
postins93721203post_ins
restrains9311623restrains
retains74522253_retains
sains55639973__s_ains
satins64930483__satins
sextains15246813sextains
staigs75414813__staigs
stain55727943__stain_
stairs65416333__stairs
statins73719773__statins
steins64818343__steins
strains74218153__strains
sustain738773sustain_
swains94513953__swains
tains54936323___tains
tearstains1043323tearstains
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.420425454.8
2DLD Change Limit146162907.06320694.0
3Display Results90900.0461956.5
 (SQL Overall)178691907.52923733.7
 
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.