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

235 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
mistral9101364(None) 
mistrals101212621mistrals
mistrial10311381mistrial
mitral81314321mi_tral
astral66919282_astral
austral73411512austral
citral81113892ci_tral
diastral946992diastral
distal73615772dist_al
estral64716512_estral
gastral8329552gastral
lustral7339652lustral
magistral1243622magistral
mineral9312732mineral
minstrel1046912minstrel
misdeal1037662misdeal
misdial1039642misdial
misdraw1345622misdraw
miskal123710262mis_kal
missal84314902mis_sal
mistrace12312642mistrace
mistrain10311942mistrain
mistreat10313112mistreat
mistrials1148132mistrials
ristra6310712ristra_
ristras7311562ristras
rostral7311332rostral
sistra639332sistra_
vestral104111012vestral
antral65719413_antral
astrals75515243_astrals
astray95615543_astray
australs8359533australs
bestial9311643bestial
bistre83815023bistr_e
bistred103311853bistred
bistres94017213bistres
bistro8339943bistr_o
bistros92810983bistros
central93114473central
cisternal11325743cisternal
cistron9299883cistron
citrals91111673ci_trals
cloistral1143543cloistral
coistrel1046743coistrel
coistril1046763coistril
costal85419513cost_al
costrel9310373costrel
dextral1577003dextral
dioptral1144683dioptral
dipteral1147003dipteral
dishrag1246273dishrag
dismal92412243dis_mal
distil73616433dist_il
distill83011323distill
distract11313023distract
distrain9412243distrain
distrait9414343distrait
dustrag945363dustrag
estray95713333_estray
estrual7367933_estrual
festal94213563fest_al
figural1145243figural
fiscal1139333fis_cal
fissural1143703fissural
fistful1365903fistful
fistula1045503fistula
gestural946033gestural
hiatal9310203hiat_al
immoral1146783immoral
instal6712193inst_al
inthral10249463_inthral
kestrel1137113kestrel
kistful1465303kistful
liberal9310193liberal
listel64214743list_el
literal7613273literal
litoral7610763litoral
littoral845273littoral
lustra6358893lustra_
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
martial92415413martial
mayoral1237693mayoral
meatal84114733meat_al
menstrual1144353menstrual
mensural1046223mensural
mental84521603ment_al
mescal104113483mes_cal
mesial84818083mes_ial
mestranol1143893mestranol
metal75427383m_et_al
miasmal1176743miasmal
micra96214973mi_cra_
midstream1443573midstream
mihrab1335523mi_hrab
mikra114610313mi_kra_
mimical1339233mimical
minerals10311373minerals
minimal114010603minimal
minstrels1145693minstrels
minutial1046423minutial
misbias1139083misbias
misbill1137033misbill
misbrand1346413misbrand
miscall1139643miscall
misdeals1147223misdeals
misdealt1147973misdealt
misdials1137493misdials
misdrawn1444343misdrawn
misdraws1445753misdraws
misdrew1335833misdrew
miseat82925703mis_eat
misenrol1044143misenrol
miser75430403miser__
miserable1349653miserable
miserably1646663miserably
miserly12329823miserly
misers85025703miser_s
misery114113543miser_y
misframe1546973misframe
misgrade1247503misgrade
misgraft1447193misgraft
misgrew1335523misgrew
misgrow1344433misgrow
mishap1338863mis_hap
mishear1238393mishear
miskals13369763mis_kals
mislay113510683mis_lay
mislead10419973mislead
mismark1536703mismark
mispart111113773mispart
misplan1147773misplan
misplay1436383misplay
misrate91319143mis_rate
misread10339723misread
misrely12319613mis_rely
misrule939353mis_rule
missals93914423mis_sals
missay114112143mis_say
misseat93617233misseat
missel85216523mis_sel
misstart10410033misstart
mist66154533mist___
mistake131312623mistake
mistbow1443993mistbow
misteach1545443misteach
misted93625823mist_ed
mistend103812523mistend
mister84728563mist_er
misterm114314513misterm
misterms123711353misterms
misters93927513misters
misteuk1335893misteuk
misthrew16124763misthrew
misthrow16134273misthrow
mistier93418713mistier
mistily122612343mistily
mistime11312613mistime
misting103623383misting
mistitle1038523mistitle
mistook1337153mistook
mistraced1439453mistraced
mistraces13312293mistraces
mistrains11511353mistrains
mistreats1148633mistreats
mistress10310703mistress
mistrust1049203mistrust
mistruth1346043mistruth
mistryst1345843mistryst
mists76633903mist__s
mistune9310653mistune
misty106120453mist__y
mistype14126523mistype
miswrit1249413miswrit
mitre75522423mi_tr_e
mitred94414343mi_tred
mitres83922073mi_tres
mitsvah1542163mitsvah
moistful1343853moistful
moral75533433m__oral
mortal84616853mort_al
mural75225103m__ural
musical1139553musical
muskrat1346733muskrat
mustard10359533mustard
mutual838503m_utual
mystical1546933mystical
neutral737923neutral
nitril62511533ni_tril
nostril749303nostril
osteal6312963_osteal
pastoral10310483pastoral
pastural1038413pastural
peytral1287503peytral
pistil83915073pist_il
pistol83313333pist_ol
plastral1046913plastral
postal84317533post_al
postoral10311723postoral
postural1049203postural
restoral8810983restoral
retral64419743_retral
rictal83113183rict_al
ritual6310623ri_tual
rostra6310933rostra_
semestral1185283semestral
seral56336383__seral
sinistral944683sinistral
sisal54217733sis__al
sistrum946563sistrum
steal56125473__steal
strap77925263__strap
straw813321293__straw
stray88525573__stray
sural55931263__sural
timbral11237193timbral
tissual745193tissual
unstrap946783unstrap
ventral103612173ventral
vestal94615573vest_al
vestural1156473vestural
victual1246253victual
viral86419593vi__ral
virtual1045913virtual
visceral1344673visceral
vista85416603vist_a_
vistas94513273vist_as
visual938803vis_ual
vital84819673vi_t_al
wastrel1037553wastrel
wistful1365713wistful
withal1238933wi_thal

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.296603685.8
2DLD Change Limit1340272357.06318975.9
3Display Results2352350.0932526.9
 (SQL Overall)1786912357.45223978.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.