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

107 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
modelist1131050(None) 
modelists1246471modelists
delist74625052__delist
medalist11414212medalist
midlist10312512mid_list
modeling12311072modeling
models94216352model_s_
modernist1246262modernist
modest93818452mode__st
moralist10316662moralist
novelist1149452novelist
sodalist9311882sodalist
codeless112010113codeless
coexist1638583co_exist
comeliest13410033comeliest
deist64633593__de_ist
delict94320333__delict
delis64928543__delis_
delish105215613__delish
delists84414173__delists
desist74818813__desist
duelist8511413_duelist
fideist1139753fide_ist
fidelista1343203fidelista
geodesist1183823geodesist
godliest1039453god_liest
holist94723213ho__list
homeliest1448553homeliest
homilist13410033homilist
idealist9310653_idealist
idylist1146653_idylist
libelist10310823libelist
localist101613963localist
loneliest949443loneliest
loveliest1246973loveliest
loyalist111511133loyalist
medalists1249373medalists
medallist1246643medallist
metalist10519353metalist
midlists1137523mid_lists
mobilise1248143mobilise
modality14117653modality
modals93914453modal_s_
model84521693model___
modeled1139463model_ed
modeler1039293model_er
modelers1138463modelers
modelings1335563modelings
modelled1236433modelled
modeller1136613modeller
modelling1336883modelling
modeming1437103modeming
modems114610763mode_ms_
modernest1248113modernest
modernise1244733modernise
modernism1444003modernism
modernists1344293modernists
moderns1037963moderns_
modes85537413mode__s_
modestest1245003modestest
modesty13476983mode__sty
modish123813543mod__ish
modiste1039283mod__iste
modules102511003modules_
moduli9267963moduli__
modulus10245333modulus_
mohelim1444763moheli_m
mohels115011323mohel_s_
moist76033583mo___ist
molest85022743mo__lest
monetise10311473monetise
monist84324983mo__nist
monodist11310923monodist
moonlit9229333moonli_t
moralise10314913moralise
moralism12312363moralism
moralists11311103moralists
morels84820013morel_s_
motels83616893motel_s_
motliest10310773mo_tliest
motorist10314413motorist
moveless1367753moveless
muralist10312983muralist
novelise1137953novelise
novelists1245933novelists
obelise9310173_obelise
obelisk1345193_obelisk
obelism1138203_obelism
oculist9310883_oculist
odalisk1265373_odalisk
odist6421913_od__ist
oralist7619633_oralist
panelist10414503panelist
polemist12412363polemist
pollist9816603po_llist
populist1248203populist
relist64628413__relist
royalist111311983royalist
sodalists1038153sodalists
sodomist1157633sodomist
solecist10910783solecist
totalist8315583totalist
totemist1049033totemist
vocalist131512123vocalist
yodeling1357673yodeling
yodels104610073yodel_s_
yokelish1843983yokelish

Search took 7 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 Limit1461621076.51622431.2
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.98225593.1
 
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.