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

66 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
mistrials114814(None) 
mistrals101212631mistr_als
mistrial10311381mistrial_
misdials1137502mis_dials
mistrains11511352mistrains
mistral91013642mistr_al_
mistreats1148632mistreats
astrals75515243_astr_als
australs8359533austr_als
citrals91111673ci_tr_als
coistrils1146433coistri_ls
distills9319043dist_ills
distils83015803dist_i_ls
distrains10411343distrains
districts1248943districts
estriols856253_estriols
historians13106303historians
imperials1347343imperials
listerias959243listeria_s
materials11510813materials
memorials1346563memorials
midstreams1542573midstreams
minerals10311393miner_als
minstrels1145693minstr_els
misbias1139083mis_bia_s
misbills1246083mis_bills
misdeals1147233mis_deals
misdial1039643mis_dial_
misdraws1445753misdr_aws
misdrives1546213misdrives
miseries10320403miseri_es
miskals13369773mis__kals
misprices1547913misprices
misprints13107223misprints
misprizes2247223misprizes
misreads11268923mis_reads
missals93914433mis__sals
misstrikes1644363misstrikes
misthinks1843353misthinks
mistily122612343mist_i_ly
mistimes12612613mist_imes
mistitle1038523mist_itle
mistitles1147953mist_itles
mistrace12312643mistr_ace
mistraces13312293mistraces
mistrain10311943mistr_ain
mistreat10313113mistrea_t
mistress10310703mistr_ess
mistrusts1146013mistrusts
mistruths1443683mistruths
mistrysts1443863mistrysts
miswrites1447983miswrites
mitral81314323mi_tr_al_
nitrils72810703ni_tri_ls
nostrils848183nostri_ls
oestriols944333oestriols
pictorials1445493pictorials
pistils93314303pist_i_ls
pretrials1158143pretrials
retrials8510823_retrials
ristras7311563ristr_a_s
serials73919753__serials
trials64319883___trials
vitriols1145053vi_triols
wistarias1246793wistaria_s
wisterias1248113wisteria_s

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 Filter1786911486410.436409841.7
2DLD Change Limit148641668.20318120.3
3Display Results66660.0164125.0
 (SQL Overall)178691668.65520646.0
 
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.