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

204 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
ironist731484(None) 
ironists839291ironists
agonist82615402agonist
arsonist8412012arsonist
cronish12310862cronish
dronish1138912dronish
hornist102314822hornist
ionise63516932i_onise
irones64724012irones_
ironic8313772ironi_c
ironies7517422ironies
ironing82414012ironing
ironize16610372ironize
irons55324132iron_s_
monist84324982_monist
protist9320222protist
simonist10410722simonist
adonis7314063adonis_
agonise83112693agonise
agonists9289833agonists
amongst1045363amongst
amorist9317643amorist
aorist64827873_aorist
arborist10411613arborist
aroint6328153aro_int
aroints7313133aroints
arsonists947413arsonists
artist64125543ar_tist
atomist92915763atomist
boniest93318993_boniest
briniest102812323briniest
brinish1239963brinish
bromism1337623bromism
broncs101611153broncs_
bronziest2035813bronziest
brownest1398893brownest
browniest14207123browniest
brownish1645643brownish
canonist10513533canonist
clonism1138983clonism
colonist102617923colonist
consist9316033_consist
corniest102117303corniest
crayonist1446243crayonist
crones84729243crones_
cronies9622503cronies
cronyism1544723cronyism
demonist11413463demonist
droit65127123dro_i_t
droits74314313dro_its
drones75023433drones_
droning93013723droning
ebonise939613ebonise
egoist7612283ego_ist
egotist8411273egotist
eonism83213533_eonism
erotism9312293erotism
florist10314243florist
foist85730973_fo_ist
fronds106412343fronds_
frons86124043fron_s_
front85029223fron__t
frontlist1246123frontlist
fronts94415793fronts_
frost84727833fro__st
frowst125512073fro_wst
girons75014373giron_s_
gnomist1049133gnomist
gooniest93213003gooniest
grist65529873gr__ist
grodiest10310553grodiest
groins73917203groins_
harmonist141310663harmonist
hedonist1249553hedonist
hoist86433213_ho_ist
holist94723213_holist
honest94822423_honest
horniest112814043horniest
hornists11208833hornists
hymnist1546633hymnist
icones84616383icones_
iconic10411593iconi_c
icons76516493icon_s_
idolise839293idolise
idolism1037273idolism
idylist1146653idylist
ikons96311013ikon_s_
imagist1077323imagist
inanest72115363inanest
insist6314503i_nsist
intwist1038043intwist
iodise74214933i_odise
iodism93611123i_odism
ionic74622653i_oni_c
ionics84214473i_onics
ionised82911493i_onised
ionises72916433i_onises
ionium8610913i_onium
ionize154613863i_onize
ions46737853i_on_s_
iratest7312483iratest
irenic8311103ireni_c
irenics937833irenics
iris45732543ir__is_
iritis63113733iritis_
irokos1037233irokos_
iron46728463iron___
irone55126363iron__e
ironed74916013iron_ed
ironer64216443iron_er
ironers74813543ironers
ironfisted1442163ironfisted
ironical1049963ironical
ironings9217583ironings
ironized1858203ironized
ironizes17510373ironizes
ironlike1235713ironlike
ironman936613ironman
ironmen936453ironmen
ironness836953ironness
ironside945853ironside
irony85015903iron__y
jargonist1746703jargonist
joist125125653_jo_ist
lionise7310373lionise
lookist1139563lookist
looniest83313253looniest
misoneist1147583misoneist
moist76033573_mo_ist
mongst93512603_mongst
monish114217593_monish
monism104016313_monism
monists93614783_monists
mooniest103014173mooniest
moonish123311043moonish
moronism1249323moronism
oboist8312683obo_ist
odist6421913__odist
ologist8313833ologist
onanist7314633onanist
oralist7619633oralist
organist9411543organist
ornis54616773or_nis_
ozonise1646443ozonise
parodist11412763parodist
peonism11611103peonism
phoniest132811533phoniest
pianist9615103pianist
plenist9314333plenist
porniest103214313porniest
probit103218353probi_t
probits112712573probits
profit113016273profi_t
profits122911243profits
promise113415843promise
prongs94314483prongs_
prosaist10611583prosaist
prosiest10416523prosiest
prosit85124593prosi_t
prost75434103pro__st
protest9317533protest
protists10313353protists
proviso1237313proviso
provost1238573provost
prowest12311533prowest
racist82822793_racist
ranis55235833_ranis_
rapist82520673_rapist
relist64628413_relist
renest64529713_renest
resist64524533_resist
rigorist949123rigorist
roast56230143_ro_ast
robust8310433_robust
ronion63315643_ronion
roost55730933_ro_ost
ropiest93317773_ropiest
rosiest73919213_rosiest
rotis56327053_rotis_
roust55532063_ro_ust
sarodist9510923sarodist
simonists1146763simonists
soonest7415593soonest
stoniest8413543stoniest
stonish10410653stonish
tanist6324593_tanist
tennist72813113tennist
toniest73218903_toniest
tonish93415903_tonish
transit7317163transit
trois57226093tro_is_
tronas63816893tronas_
trones65629283trones_
tropism1139293tropism
unionist8410343unionist
uranism91112513uranism
urbanist10109073urbanist
utopist938693utopist
violist10312143violist
virosis1039023virosis_
wrist84827563wr__ist
wrongest1236733wrongest
wrongs10338933wrongs_
yonis85020823_yonis_

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272048.58015620.9
3Display Results2042040.0762684.2
 (SQL Overall)1786912048.81220278.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.