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

226 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
distain831378(None) 
destain8412081destain
disdain938511disdain
distains9413601distains
distrain9412241distrain
abstain947252abstain
destains9311812destains
detain74617382d_etain
disdains1037912disdains
disjoin1547642disjoin
distaff1467682distaff
distained1139602distained
distal73615772dista_l
distant83519952distant
distil73616432dist_il
distrains10411332distrains
distraint101112902distraint
distrait9414342distrait
dustbin1044542dustbin
histamin1387042histamin
isatin6412212_isatin
mislain9311242mislain
mistrain10311942mistrain
stain55727942__stain
sustain738772sustain
abstains1047323abstains
attain6311753_attain
biotin83215833biot_in
bistate9313823bistate
captain112111063captain
certain92612213certain
cistern93310703cistern
cistron9299883cistron
citrin82615413ci_trin
contain9315833contain
curtain9319793curtain
cystein1246053cystein
dastard9279703dastard
deistic10311173deist_ic
deltaic1037023deltaic
dentin73919573dent_in
desman9311693desma_n
despair1045463despair
destained1158253destained
destine83719953dest_ine
destiny113111463dest_iny
detail74516433d_etail
detains83716093d_etains
detrain8412253detrain
dextrin1587543dextrin
diamin9312523di_amin
diastase946603diastase
diastasic1244033diastasic
diastatic1245943diastatic
diatron839283diatron
diazin1639163di_azin
dicta84915633dicta__
dictate10311663dictate
dictating1338883dictating
dictation12810563dictation
diction102313053diction
dietary1158663dietary
dieting93616833diet_ing
digitalin1154103digitalin
digoxin1644943digoxin
diktat11310693dikta_t
diktats1235623diktats
dilating102714913dilating
dilation92215463dilation
dinting93520553dint_ing
dioxan1465773dioxa_n
dioxin14118783di_oxin
dirtying1336093dirtying
disarm9310473dis_arm
disband1138243disband
disbar938513disba_r
disbars10310323disbars
discant103017263discant
discard11310213discard
discase102912863discase
discasing1339433discasing
discern1038493discern
disci85815023dis_ci_
discing113914593dis_cing
disclaim1345643disclaim
discoid11311243discoid
discoing12511453discoing
disdained1246023disdained
disease83213843disease
diseasing11310833diseasing
disentail1047083disentail
dishing124017103dis_hing
dishpan13105523dishpan
disjoins1647623disjoins
disjoint1649233disjoint
disking134615493dis_king
dislimn1056103dislimn
dismal92412243disma_l
dismals102010243dismals
dismast10311233dismast
dismay12229473disma_y
dismaying1656823dismaying
dismays13237433dismays
disomic1238763disomic
disown1036953dis_own
dispart101115283dispart
disrate81418523disrate
disrating11714553disrating
dissave1139413dissave
dissaving1436953dissaving
dissing94517683dis_sing
distaffs1565083distaffs
distaining1248903distaining
distally1239553distally
distance11311853distance
distancing1447083distancing
distaste939943distaste
distasting1248023distasting
distaves12311403distaves
distend93312073distend
distent84120853distent
distich13312173distich
distill83011323distill
distils83015803distils
distinct11410763dist_inct
distome10313233distome
distort81120333distort
distract11313023distract
distrained1257673distrained
distrainer1146433distrainer
distrainor1163393distrainor
distraints1166873distraints
distraite10611483distraite
district11413873district
disturb1046233disturb
disunion956113disunion
disusing1039003disusing
dita56032523di_ta__
ditas65923673di_ta_s
dittany1135653dittany
dittoing1036263dittoing
divan96114843di_va_n
diwan95712553di_wa_n
domain9511323d_omain
drain65222893d__rain
driftpin1441843driftpin
dustbins1144593dustbins
dusting93618993dust_ing
dustman1044683dustman
dustmen1035773dustmen
dustpan1043243dustpan
dystaxia19123453dystaxia
einstein844183einstein
eiswein1043503eiswein
estrin6315923_estrin
fishtail1443983fishtail
fistic11812573fist_ic
fisting113818123fist_ing
fusain958643fus_ain
fustian1036903fustian
gastrin839833gastrin
gittin72910553gi_ttin
histamine1476903histamine
histamins1476723histamins
histidin1244933histidin
histing113720373hist_ing
histoid1139823histoid
isatine7311763_isatine
isatins7310773_isatins
listen64816813list_en
listing84020593list_ing
litai55216363li_tai_
maintain1077723maintain
misaim10311853mis_aim
miscoin11311433miscoin
misjoin1637693misjoin
mislaid1039303mislaid
mispaint121111893mispaint
missaid10310303missaid
mistake131312623mistake
mistaken14147833mistaken
mistaking1699693mistaking
misthink1745433misthink
misting103623383mist_ing
mistrains11511353mistrains
nystatin1145093nystatin
obtain839183_obtain
oestrin7312243oestrin
pertain92714963pertain
pigtail1046623pigtail
pintail9311183pintail
pistil83915073pist_il
piston83515923pist_on
postin83521033post_in
quintain17316223quintain
restrain8311703restrain
retain64523283_retain
sain45551293__s_ain
satin55935223__satin
sextain14257103sextain
siskin1079783sis_kin
slain54923573__slain
staid66722083__staid
staig65519643__staig
stains64923653__stains
stair54719943__stair
statin63921473__statin
stein54620543__stein
strain64919573__strain
sustains838553sustains
swain84919053__swain
tain45548073___tain
titan53318173ti_ta_n
titian62512663ti_tian
upstair943983upstair
villain1038483villain
visaing11279333vis_aing
vista85416603vista__
vistaed1138023vistaed
vistas94513273vista_s
vitamin1237423vi_tamin
vitrain1038943vitrain
wistaria1146623wistaria
wisting113519743wist_ing
witan83816503wi_ta_n
within123611383wi_thin

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272266.61020276.4
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.10925135.9
 
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.