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

222 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
distains941360(None) 
destains9311811destains
disdains1037911disdains
distain8313781distain_
distrains10411331distrains
abstains1047322abstains
destain8412082destain_
detains83716092d_etains
disdain938512disdain_
disjoins1647622disjoins
distaffs1565082distaffs
distained1139602distained
distant83519952dista_nt
distaves12311402distaves
distils83015802dist_ils
distrain9412242distrain_
distraint101112902distraint
distraints1166872distraints
dustbins1144592dustbins
histamins1476722histamins
isatins7310772_isatins
mistrains11511352mistrains
stains64923652__stains
sustains838552sustains
abstain947253abstain_
attains7310983_attains
biotins93114453biot_ins
captains121810573captains
cisterns10369573cisterns
cistrons102710623cistrons
citrins92614363ci_trins
contains10316533contains
curtains10259703curtains
cysteins1355733cysteins
dastards10278083dastards
dentins83419223dent_ins
desmans1039003desma_ns
despairs1144943despairs
destained1158253destained
destine83719953dest_ine
destines93619663dest_ines
destiny113111463dest_iny
details84214043d_etails
detain74617383d_etain_
detrains9411763detrains
dextrins16117823dextrins
diamins10312213di_amins
diastases1047073diastases
diatrons939613diatrons
diazins1739183di_azins
dictates11311383dictates
dictating1338883dictating
dictations1389703dictations
dictions111812673dictions
dietaries10410663dietaries
dieting93616833diet_ing
digitalins1254023digitalins
digoxins1744293digoxins
diktats1235623dikta_ts
dilating102714913dilating
dilations102614453dilations
dinting93520553dint_ing
dioxans1555313dioxa_ns
dioxins1568003di_oxins
dirties83119383dirt_ies
dirtying1336093dirtying
disarms1039043dis_arms
disband1138243disba_nd
disbands1237353disbands
disbars10310323disba_rs
discant103017263disca_nt
discants112912023discants
discards1238913discards
discases112014503discases
discasing1339433discasing
discerns1138163discerns
discing113914593dis_cing
disclaims1444853disclaims
discoids1239873discoids
discoing12511453discoing
disdained1246023disdained
diseases92415813diseases
diseasing11310833diseasing
disentails1147013disentails
dishing124017103dis_hing
dishpans14115833dishpans
disjoin1547643disjoin_
disjoint1649233disjoint
disjoints1745473disjoints
disking134615493dis_king
dislimns1144813dislimns
dismals102010243disma_ls
dismasts1137513dismasts
dismaying1656823dismaying
dismays13237433disma_ys
dismiss1038153dis_miss
disowns1136733dis_owns
disparts11109953disparts
disrates91118153disrates
disrating11714553disrating
dissaves1239413dissaves
dissaving1436953dissaving
dissing94517683dis_sing
distaff1467683dista_ff
distaining1248903distaining
distal73615773dista__l
distally1239553distally
distance11311853distance
distances12311653distances
distancing1447083distancing
distaste939943distaste
distastes1039633distastes
distasting1248023distasting
distend93312073dist_end
distends10339823distends
distent84120853dist_ent
distich13312173dist_ich
distichs1447633distichs
distil73616433dist_i_l
distill83011323dist_ill
distills9319043distills
distinct11410763dist_inct
distomes11314163distomes
distorts91112353distorts
distracts1249283distracts
distrained1257673distrained
distrainer1146433distrainer
distrainers1255053distrainers
distrainor1163393distrainor
distrainors1252923distrainors
distrait9414343distrai_t
distraite10611483distraite
distress9311713distress
district11413873district
districts1248933districts
disturbs1145403disturbs
disunions1055973disunions
disusing1039003disusing
ditas65923673di_ta__s
dittanies1045733dittanies
dittany1135653ditta_ny
ditties83116983di_tties
dittoing1036263dittoing
divans104612393di_va_ns
diwans105110373di_wa_ns
domains10510873d_omains
drains73719403d__rains
driftpins1541833driftpins
dustbin1044543dustbin_
dusting93618993dust_ing
dustings10419033dust_ings
dustpans1143233dustpans
dystaxias20163233dystaxias
einsteins944153einsteins
eisweins1143383eisweins
estrins7315853_estrins
fishtails1543663fishtails
fisting113818123fist_ing
fusains1038363fus_ains
fustians1146403fustians
gastrins9310123gastrins
histamin1387043histamin_
histamine1476903histamine
histamines1575893histamines
histidins1345073histidins
histing113720373hist_ing
isatin6412213_isatin_
isatine7311763_isatine
isatines8310663_isatines
listens74014133list_ens
listing84020593list_ing
listings93310043list_ings
maintains1167103maintains
misaims11310113mis_aims
miscoins12311083miscoins
misjoins1736913misjoins
mislain9311243mislain_
mispaint121111893mispaint
mispaints13106183mispaints
mistakes141213413mistakes
mistaking1699693mistaking
misthink1745433misthink
misthinks1843353misthinks
misting103623383mist_ing
mistrain10311943mistrain_
nystatins1244753nystatins
obtains939163_obtains
oestrins8312673oestrins
pertains102113423pertains
pigtails1146033pigtails
pintails10310163pintails
pistils93314303pist_ils
pistons93016373pist_ons
postins93721203post_ins
quintains18306033quintains
restrains9311623restrains
retains74522253_retains
sains55639973__s_ains
satins64930483__satins
sextains15246813sextains
siskins1159583sis_kins
staigs75414813__staigs
stain55727943__stain_
stairs65416333__stairs
statins73719773__statins
steins64818343__steins
strains74218153__strains
sustain738773sustain_
swains94513953__swains
tains54936323___tains
titans63414913ti_ta_ns
titians72710453ti_tians
upstairs1043643upstairs
villains1138013villains
visaing11279333vis_aing
vistas94513273vista__s
vitamins1347083vi_tamins
vitrains1138283vitrains
wistarias1246793wistarias
wisting113519743wist_ing
witans93412933wi_ta_ns
withins133511693wi_thins

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 Limit1461622226.61022112.3
3Display Results2222220.0932387.1
 (SQL Overall)1786912227.12325086.5
 
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.