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

109 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
onanists83841(None) 
onanisms1048061onanisms
onanist7314631onanist_
botanists1148202botanists
nanisms938832_nanisms
onanism9310132onanis_m
onanistic1147372onanistic
oralists8611802oralists
organists1047382organists
pianists1049012pianists
tanists7313652_tanists
womanists1446762womanists
agists75713173__agists
agonists9289833agonists
analysts11167443analysts
anapests1046613anapests
angsts738863__angsts
animists103010633animists
anises64826693__anises
annalists949063annalists
atavists1137583atavists
atonalists1048493atonalists
bongoists1244843bongoists
botanises1139163botanises
botanist10412033botanist_
canonists1158513canonists
cladists1136723cladists
colonists112512503colonists
consists10310593con_sists
czarists1966223czarists
dialists9411413dialists
diarists9410363diarists
dualists958243dualists
dynamists1544093dynamists
enlists749393en_lists
entwists1156143entwists
finalists123010163finalists
gnomists1145473gnomists
hornists11208833hornists
humanists1446843humanists
hymnists1644903hymnists
imagists1175113imagists
inanest72115363inanest_
inanity1039503inani_ty
insists739083in_sists
intwists1145593intwists
ironists839293ironists
kyanises15206393kyanises
localists11149793localists
loyalists12137473loyalists
lutanists966843lutanists
maists85817573_ma_ists
melanists1148623melanists
monadisms1446253monadisms
monists93614783_monists
monodists1247703monodists
moralists11311103moralists
nanism8311203_nanis_m
narcists1078113_narcists
nonartists1046403nonartists
nonpapists1443953nonpapists
nudists8356833_nudists
oasts56529183o_a__sts
oboists937903o_boists
oculists1037133oculists
odalisks1363503odalisks
odists749853o__dists
oghamists1543033oghamists
ologists939443ologists
oneness7512143onenes_s
oralisms10610973oralisms
oralist7619633oralist_
organises1048683organises
organisms1247213organisms
organist9411543organist_
oxalises1538503oxalises
ozonises1776373ozonises
paganists1247643paganists
papists112110453_papists
pianisms1249013pianisms
pianist9615103pianist_
plenists1038253plenists
racists92613323_racists
rapists92510753_rapists
realists83014843realists
romanises11311573romanises
royalists12178113royalists
sadists83310853_sadists
satanists948233satanists
sodalists1038153sodalists
sonants7511233sonan__ts
statists8310163statists
tanist6324593_tanist_
tennists8297793tennists
totalists9310753totalists
transits8313503transits
tsarists857303tsarists
tzarists1755693tzarists
unionists946213unionists
unknits1135553unkni_ts
untwists1144623untwists
uranisms1099973uranisms
urbanists11105483urbanists
vocalists14108893vocalists
votarists1298603votarists
waists97415453_wa_ists
womanises1448063womanises
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 Filter1786911461620.420425454.8
2DLD Change Limit1461621096.83021400.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.29624491.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.