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

142 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
poloists1091052(None) 
pollists10910821pollists
poloist91016321poloist_
soloists869151soloists
apologists1348882apologists
colonists112512502colonists
colorists112313592colorists
holists104413962hol_ists
oboists937902_oboists
ologists939442_ologists
oologists1039852oologists
palmists12268812palmists
polemists1348602polemists
pollist9816602pollist_
prologists13311172prologists
soloist7915892soloist_
volosts1036562volo_sts
ableists1036543ableists
altoists848753altoists
aorists74215833ao_rists
apologises1347303apologises
apologist12412403apologist_
biologists1349433biologists
bongoists1244843bongoists
boosts86115013bo_o_sts
cellists1038563cellists
coexists1735653coexists
cohosts12398813coho_sts
colonises112814013colonises
colonist102617933colonist_
colorisms132810793colorisms
colorist102818993colorist_
colossus1045183colossus
consists10310593consists
copyists1545993copyists
cosmists1237993cosmists
cultists10107633cultists
delists84414173del_ists
dodoisms1244523dodoisms
ecologists13310923ecologists
egoists887073_egoists
enlists749393enl_ists
enologists11310623enologists
eulogists1046653eulogists
florists1138813florists
foists95413983__foists
geologists1279163geologists
glosts74513813_glo_sts
hoboisms1545563hoboisms
hoists95516023__hoists
holisms123811113hol_isms
holist94723213hol_ist_
hornists11208833hornists
joists134711033__joists
judoists1643653judoists
lists56628693__l_ists
locoisms1256143locoisms
lookists1245713lookists
melodists1246633melodists
molests93311563mol_ests
monists93614783mo_nists
monodists1247703monodists
motorists1149913motorists
myologists1648203myologists
neologists1139773neologists
oboist8312683_oboist_
odists749853_o_dists
ologist8313833_ologist_
oologist9313493oologist_
orologists1149823orologists
otologists1149633otologists
palmist112814343palmist_
papists112110453p_apists
parodists1248513parodists
pedologists1548273pedologists
peltasts1035703peltasts
pelvises1337273pelvises
penologists1449593penologists
persists1049183persists
phallists1445723phallists
pianists1049013pianists
piccoloists1752773piccoloists
pietists1038323pietists
pilosity1366323pilosity
pilots84018873pilo__ts
plaints94012053p_laints
plaits83816473p_lai_ts
plenists1038253plenists
plots75025673p_lo__ts
pocosins1258953pocosins
poetises10313953poetises
pogromists1543613pogromists
points85618533p__oints
poises84226543p__oises
polarises11514073polarises
polecats1248833polecats
poleis86018353polei__s
polemist12412363polemist_
polices113118053pol_ices
polies84034583pol_i_es
polios84019723pol_i_os
polis74731163pol_i__s
polish114916723pol_is_h
polishes13711783pol_ishes
polite83625073pol_i_te
polity113015863pol_i_ty
pollices12410753pollices
polonaises1245723polonaises
poloniums1346053poloniums
polos76129913polo___s
polycots1547763polycots
pomologists1648983pomologists
populists1345493populists
porisms113713453po_risms
porosity1348593porosity
porpoises1348433porpoises
posits85718713po_si_ts
posts75228783p__o_sts
prologist12315083prologist_
prosaists1157503prosaists
prosodists1345943prosodists
protists10313363protists
provosts1336083provo_sts
psalmists1344073psalmists
pulpits1137243pulpi_ts
purists94014073p_urists
relists73817053rel_ists
roosts64916323ro_o_sts
sodomists1255923sodomists
solecists1187073solecists
soloistic1147333soloistic
solonets838233solonets
sophists1347293sophists
sumoists1046733sumoists
topologists1447863topologists
tourists838313tourists
typologists1746813typologists
ufologists1445423ufologists
urologists1148413urologists
violists1137663viol_ists
volost9412643volo_st_
zoologists2047173zoologists

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.406440125.6
2DLD Change Limit1461621427.37619815.9
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.84222786.4
 
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.