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

95 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
abstain94725(None) 
abstains1047321abstains
abstained1245052abstained
abstainer1144402abstainer
attain6311752a_ttain
destain8412082destain
distain8313782distain
obtain839182ob_tain
stain55727942__stain
sustain738772sustain
abating10413973abat_ing
abatis84317933abat_is
abattis9297823abattis
abelian92810643abelian
abetting1158293abetting
abigail1044193abigail
ablating11312003ablating
ablation10312433ablation
abscisin1243973abscisin
abseil837183abs_eil
abstainers1243453abstainers
abstaining1344573abstaining
abstract1249223abstract
abstrict1257943abstrict
abutting1137003abutting
acetin8314693acet_in
actin74922553a_ct_in
again65218123a__gain
amain74922913a__main
arshin9312173ars_hin
assai5711543a_ssai_
assail6610153a_ssail
assais6711963a_ssais
astasia7310933a_stasia
astatic9514193a_static
astatine8313533a_statine
astern64815813a_stern
astir55517093a_st_ir
attains7310983a_ttains
attaint7313473a_ttaint
atwain937813a_twain
bargain1079063bargain
basin75026923bas__in
bastard103012423bastard
basting104227203bast_ing
bastion9312473bastion
betaine9413783_betaine
blain75421793_b_lain
brain76229383_b_rain
cabstand1344413cabstand
capstan1137903capsta_n
captain112111063captain
certain92612213certain
contain9315833contain
curtain9319793curtain
cystein1246053cystein
destains9311813destains
detain74617383_detain
disdain938513disdain
distains9413603distains
distrain9412243distrain
dustbin1044543dustbin
estrin6315923_estrin
fusain958643fus_ain
fustian1036903fustian
gastrin839833gastrin
habitan1236903habita_n
histamin1387043histamin
isatin6412213_isatin
maintain1077723maintain
mislain9311243mislain
mistrain10311943mistrain
nystatin1145093nystatin
obtains939163ob_tains
oestrin7312243oestrin
pertain92714963pertain
postin83521033post_in
restrain8311703restrain
retain64523283_retain
sain45551293__s_ain
satin55935223__satin
sextain14257103sextain
slain54923573__slain
staid66722083__staid
staig65519643__staig
stains64923653__stains
stair54719943__stair
statin63921473__statin
stein54620543__stein
strain64919573__strain
sustains838553sustains
swain84919053__swain
tain45548073___tain
tearstain943433tearstain
upstair943983upstair

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 Filter1786911340270.403443402.0
2DLD Change Limit134027956.30021274.1
3Display Results95950.0462065.2
 (SQL Overall)178691956.74926476.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.