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

132 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
onanism931013(None) 
nanism8311201_nanism
onanisms1048061onanisms
onanist7314631onanist
monadism1348022monadism
nanisms938832_nanisms
onanists838412onanists
oralism9513762oralism
organism1148392organism
pianism11611032pianism
uranism91112512uranism
womanism1548112womanism
agism84614063__agism
animism113510213animism
anis45746463__anis_
anise55129703__anise
atavism1238033atavism
atonalism1148463atonalism
baalism11310593baalism
banish111416043_banish
binarism1248353binarism
bonacis11310323bonacis_
botanise1039643botanise
botanist10412033botanist
boyarism1546393boyarism
charism14712203charism
cladism1238553cladism
clonism1138983clonism
cocainism1545833cocainism
cranium11911103cranium
czarism2056423czarism
danish101513793_danish
donnish11187633don_nish
dualism1049163dualism
dynamism1643733dynamism
eonism83213533_eonism
etatism9610293etatism
evanish1337653evanish
favism1437913_favism
finalism133010363finalism
giantism1155383giantism
honans94814503honan_s_
humanism1548093humanism
imagism1285083imagism
inanes62519803inanes_
inanest72115363inanest
inanity1039503inanity
iotacism1246893iotacism
jnanas13207303jnanas_
knavish1743993knavish
kyanise14236143kyanise
localism121310013localism
loyalism13167573loyalism
mannish121710693mannish
melanism1239363melanism
monachism1844933monachism
monadisms1446253monadisms
monism104016313_monism
moralism12312363moralism
moronism1249323moronism
nabis76020583_nabis_
nanas55928633_nanas_
nans46139403_nan_s_
narcism1188733_narcism
naris55735293_naris_
nazis145216083_nazis_
nomadism1346403nomadism
nomism103010953_nomism
nudism9357913_nudism
oafish121311723o_afish
oasis56422553o_asis_
obeahism1542873obeahism
obelism1138203obelism
obiism1036363o_biism
odalisk1265373odalisk
ogreism1044233ogreism
ogrism937913o_grism
okapis1235393okapis_
onanistic1147373onanistic
oneness7512143oneness
onium73115533o__nium
oralisms10610973oralisms
oralist7619633oralist
orangish1246553orangish
orangs74116033orangs_
organise939323organise
organisms1247213organisms
organist9411543organist
ornis54616773o_rnis_
orphism1446183orphism
oxalis1339223oxalis_
ozonise1646443ozonise
paeanism1248703paeanism
paganism1369113paganism
papism122211513_papism
peonism11611103peonism
pianisms1249013pianisms
pianist9615103pianist
planish12412053planish
plenism11310113plenism
racism103214193_racism
ranis55235833_ranis_
realism93115923realism
romanise10312133romanise
royalism13128473royalism
sadism94113493_sadism
satanism1039673satanism
sinapism1245573sinapism
solarism10810383solarism
sonants7511233sonants_
statism9412283statism
tanist6324593_tanist
tannish101610573tannish
titanism1048213titanism
tokenism1445403tokenism
tonnish10149093ton_nish
totalism10311093totalism
tsarism958253tsarism
tzarism1866323tzarism
unais53420773una_is_
unionism1047013unionism
uranisms1099973uranisms
uranium9610023uranium
urbanism12107213urbanism
vanish121513213_vanish
veganism1446443veganism
vocalism15159043vocalism
volcanism1645233volcanism
womanise1348733womanise
womanish1646823womanish
womanisms1646893womanisms
womanist13410433womanist

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.406440125.6
2DLD Change Limit1340271327.10618861.1
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.57523589.6
 
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.