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

110 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
mistrial1031138(None) 
mistral91013641mistr_al
mistrials1148141mistrials
misdial1039642mis_dial
mistrain10311942mistrain
mistrals101212632mistr_als
mistreat10313112mistreat
mitral81314322mi_tr_al
astral66919283_astr_al
atrial65418943__atrial
austral73411513austr_al
bestial9311643best_ial
cisternal11325743cisternal
citral81113893ci_tr_al
coistril1046773coistri_l
diastral946993diastr_al
distal73615773dist__al
distil73616433dist_i_l
distill83011323dist_ill
distrain9412243distrain
distrait9414343distrait
district11413873district
estral64716513_estr_al
estriol747553_estriol
estrual7367933_estrual
filarial1147863filarial
fimbrial1544193fimbrial
gastral8329553gastr_al
historian12128103historian
historical1545923historical
iatrical1049273_iatrical
imperial1249023imperial
ischial1246423_ischial
listeria839453listeria_
listerias959243listerias
lustral7339653lustr_al
magisterial1452743magisterial
magistral1243623magistr_al
malarial10410613malarial
manorial10311083manorial
manurial1047793manurial
martial92415413mart_ial
material10314113material
memorial1249523memorial
menstrual1144353menstrual
mesial84818083mes__ial
metrical12311593m_etrical
midstream1443573midstream
miliarial1147223miliarial
mineral9312743miner_al
ministerial1354553ministerial
minstrel1046913minstr_el
minutial1046423minutial
misbias1139083mis_bias
misbill1137033mis_bill
misdeal1037663mis_deal
misdials1137503mis_dials
misdraw1345623misdr_aw
misdrive1446683misdrive
miseries10320403miseries
miskal123710263mis__kal
misprice1448133misprice
misprint12912973misprint
misprize2147543misprize
misread10339723mis_read
missal84314903mis__sal
misstrike1544893misstrike
misthink1745433misthink
mistier93418713mist_ier
mistily122612343mist_ily
mistime11312613mist_ime
misting103623383mist_ing
mistitle1038523mist_itle
mistrace12312643mistrace
mistrains11511353mistrains
mistreats1148633mistreats
mistress10310703mistress
mistrust1049203mistrust
mistruth1346043mistruth
mistryst1345843mistryst
miswrit1249413miswri_t
miswrite1348923miswrite
mitring103514143mi_tring
mystical1546933mystical
nitril62511533ni_tri_l
nostril749303nostri_l
oestriol845383oestriol
pictorial1348403pictorial
pistil83915073pist_i_l
posttrial1146513posttrial
pretrial10511983pretrial
rasorial848223rasorial
retrial7615553_retrial
ristra6310713ristr_a_
ristras7311563ristr_as
rostral7311333rostr_al
semestrial1274543semestrial
serial64625863__serial
sistra639333sistr_a_
stria55723213__stria_
striae65422273__striae
trial54926353___trial
vestral104111013vestr_al
vicarial1347793vicarial
vitriol1045693vi_triol
vizirial2043473vizirial
wistaria1146623wistaria_
wistarias1246793wistarias
wisteria1147773wisteria_
wisterias1248113wisterias

Search took 9 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.656272394.8
2DLD Change Limit1461621107.62619166.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.32821456.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.