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

207 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
oralists861180(None) 
moralists11311101moralists
oralisms10610971oralisms
oralist7619631oralist_
arbalists1148482arbalists
dialists9411412dialists
dualists958242dualists
formalists15217622formalists
localists11149792localists
loyalists12137472loyalists
moralises11314002moralises
moralisms13410292moralisms
moralist10316662moralist_
muralists1148162muralists
oculists1037132oculists
odalisks1363502odalisks
onanists838412onanists
oralism9513762oralis_m
orality101111682orali_ty
organists1047382organists
oxalises1538502oxalises
racists92613322_racists
rapists92510752_rapists
realists83014842realists
relists73817052_relists
royalists12178112royalists
ruralists947642ruralists
sodalists1038152sodalists
totalists9310752totalists
vocalists14108892vocalists
aerialists1089523aerialists
agists75713173__agists
alist56136783__alist_
amoralisms1447043amoralisms
analysts11167443analysts
annalists949063annalists
aorists74215833aor__ists
arbalests1144123arbalests
arbalist10313333arbalist_
artists74215593ar_tists
atavists1137583atavists
atonalists1048493atonalists
baalisms1238033baalisms
biblists1236873biblists
botanists1148203botanists
braillists1263663braillists
braises93818873bra_ises
braless92910563brales_s
cabalists1339153cabalists
cellists1038563cellists
ceramists1346723ceramists
cladists1136723cladists
cyclists1545713cyclists
czarists1966223czarists
delists84414173_delists
dialist8517763dialist_
diallists1056003diallists
diarists9410363diarists
dualisms1147213dualisms
dualist8614053dualist_
duelists966003duelists
enlists749393_enlists
fatalists12310023fatalists
finalists123010163finalists
focalises14139953focalises
forklifts1941973forklifts
formalises15258993formalises
formalisms17227243formalisms
formalist141910643formalist_
formulists15204703formulists
fraises104215693fra_ises
galiots82311323_galiots
globalists1344693globalists
grists74716483gr__ists
harpists1338103harpists
heraldists1443953heraldists
herbalists1546193herbalists
holists104413963_holists
homilists1456803homilists
hornists11208833hor_nists
idealists1047223idealists
idylists1244123idylists
imagists1175113imagists
immoralists1554763immoralists
ironists839293ironists
journalists1853633journalists
kabalists1546293kabalists
kraits104912203kra_i_ts
legalists1047943legalists
lists56628693___lists
localises111411463localises
localisms13148733localisms
localist101613963localist_
loyalisms14156623loyalisms
loyalist111511133loyalist_
maists85817573_ma_ists
medalists1249373medalists
metalists11412663metalists
midlists1137523midlists
modelists1246473modelists
moralise10314913moralis_e
moralised1239663moralised
moralism12312363moralis_m
moralistic1446803moralistic
morality131110333morali_ty
moralizes20312863moralizes
muralist10312983muralist_
narcists1078113narcists
neorealists1165283neorealists
normalises12228503normalises
novelists1245933novelists
oarless73913373oarles_s
oasts56529183o_a__sts
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
oblasts947293o_blasts
oboists937903o_boists
oculist9310883oculist_
odalisk1265373odalis_k
odists749853o__dists
oghamists1543033oghamists
ologists939443ologists
onanisms1048063onanisms
onanist7314633onanist_
ooralis7312553oorali__s
opalines10311423opalines
oralities91214123oralities
orals55826483oral___s
orations81515803orations
orbits84211443or_bi_ts
orbless937493orbles_s
orchises1338773orchises
organises1048683organises
organisms1247213organisms
organist9411543organist_
orgiasts943803orgiasts
orologists1149823orologists
orphisms1545993orphisms
orrises71312233or_rises
outlasts8108713outlasts
ovality1377593ovali_ty
oxalis1339223oxali__s
ozalids1794063ozali_ds
palmists12268813_palmists
papists112110453_papists
phallists1445723phallists
pianists1049013pianists
playlists1444783playlists
pluralists1245363pluralists
pollists10910823pollists
populists1345493populists
praises94121103pra_ises
pralines102217723pralines
praxises1739063praxises
protists10313363protists
psalmists1344073psalmists
racisms112310813_racisms
racist82822793_racist_
raises64826543_ra_ises
rallyists1243333_rallyists
rapist82520673_rapist_
realises82420183realises
realisms102212163realisms
realist73225383realist_
relicts94414593_relicts
relist64628413_relist_
resists74414923_resists
roasts64915413roa__sts
royalisms14127263royalisms
royalist111311983royalist_
ruralises939123ruralises
ruralisms1147353ruralisms
ruralist8311703ruralist_
sadists83310853_sadists
sealifts1135473sealifts
serialists10810363serialists
shortlists1344083shortlists
socialists1248493socialists
sodalist9311883sodalist_
statists8310163statists
stylists11207023stylists
tanists7313653_tanists
titlists837293titlists
totalises9311783totalises
totalisms1139813totalisms
totalist8315583totalist_
traits65121983tra_i_ts
transits8313503transits
tribalists1286933tribalists
tsarists857303tsarists
tzarists1755693tzarists
uralite71714103urali_te
uralites82112723uralites
uranisms1099973uranisms
urbanists11105483urbanists
valises103516263_valises
verbalists1546153verbalists
violists1137663violists
vitalists1239223vitalists
vocalises141710333vocalises
vocalisms16138053vocalisms
vocalist131512123vocalist_
votarists1298603votarists
waists97415453_wa_ists
womanists1446763womanists
wrists95415643wr__ists

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.1531167915.0
2DLD Change Limit1461622077.23620199.3
3Display Results2072070.0932225.8
 (SQL Overall)1786912077.48223882.8
 
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.