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

172 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
publics1320714(None) 
public12238141public_
cubics123810162cub_ics
pubic114513722pub_ic_
pubis94616472pub_i_s
publican1444542publican
publicans1544112publicans
publicise1544222publicise
publicist1545032publicist
publicly1743312publicly
publish1447912publish
pulis74225602pu_li_s
purlins93415422purlins
republics1542782republics
rubrics1177092rubrics
ablins8316193_ablins
abulias93210693abulias
abulic106411423abulic_
aiblins9311473aiblins
aulic74420243au_lic_
beylics1436183beylics
blips95615783__blips
bliss75616913__bliss
blocs95219653__blocs
bubalis11359903bubali_s
bubbies103913513bubbies
bubblies1166773bubblies
bucolics1443863bucolics
bulbils11338333bulbils
bullies94121893bullies
bustics11810883bustics
colics104219903_colics
cubbies133312883cubbies
cubic114313423cub_ic_
cubits103714033cub_its
cuboids1236723cuboids
culices113713123cu_lices
cullies94419963cullies
cullis84115993culli_s
dubbins12358803dubbins
dulias71212743du_lias
dunlins849553dunlins
ecbolics1444003ecbolics
fabrics1436093fabrics
flics105418363__flics
frolics1236833frolics
fustics1279593fustics
garlics1038013garlics
goblins1039243goblins
gullies84717313gullies
hubbies143211563hubbies
hubris11218973hubri_s
hurlies103315333hurlies
italics936993italics
jubiles16289373jubiles
lubric1097983lubric_
luetics937323luetics
muclucs1343683muclucs
muhlies1238933muhlies
musics103911783mu_sics
muslins9312213muslins
niblick1544453niblick
niblicks1643763niblicks
nubbins11268023nubbins
nubias8310093nub_ias
outlies72421993outlies
pablums1345123pablums
panics103815363p_anics
paulins9312613paulins
pelvics14245643pelvics
peptics132610243peptics
phobics16286703phobics
phonics143110723phonics
photics142810483photics
phylic16279553phylic_
physics17265963physics
picnics13297343picnics
pics85633913p___ics
pilis75825203p_ili_s
plica9613373p__lica
plies74526513p__lies
poetics11312073poetics
police102918563p_olice
polices113118053p_olices
policy133211513p_olicy
polies84034583p_olies
polios84019723p_olios
polis74731163p_oli_s
pollices12410753pollices
poplins11313153poplins
prelims1139823prelims
pubes94423403pub__es
publicised1743143publicised
publicises1644243publicises
publicists1643343publicists
publicity1845033publicity
publicize2444243publicize
publicizes2544073publicizes
publicness1642453publicness
publishes1645933publishes
pubs85029213pub___s
pudic104614563pu_dic_
pueblos1134843puebl_os
puffins15278913puffins
pulers83820283pu_lers
pules74538813pu_l_es
puli65527623pu_li__
pulik113613303pu_li_k
puling93621403pu_ling
pulings103511323pu_lings
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pulling103821073pulling
pulls74425053pu_l_ls
pullups1134233pullups
pulpits1137243pulpits
pulps95116483pu_l_ps
puls65437563pu_l__s
pulses83818663pu_lses
pumice1238223pu_mice
pumices1338273pu_mices
pundits10379293pundits
punjis1536693punji_s
punkies134216803punkies
punkins133111113punkins
punties94520783punties
pupils10389913pu_pils
puppies103212623puppies
purblind1345163purblind
purins83722653pu_rins
puris75332023pu_ri_s
purlieu938143purlieu
purlieus1034633purlieus
purlin83615863purli_n
purline93516533purline
purlines103514053purlines
purling103620293purling
purlings113910283purlings
purloins1077033purloins
purls74723353purl__s
pusleys12286233pusleys
puslike1347563puslike
pussies93615693pussies
pusslies1036173pusslies
putlogs1065083putlogs
putties94420023putties
pyknics1842483pyknics
qubits173710353qub_its
relics84517903_relics
republic1442983republic_
rubbies114114113rubbies
rubies84420343rub_ies
rubles83921703rubl_es
rubric1097823rubric_
rustics9810733rustics
sublets92616703sublets
sublime11310363sublime
sublimes12310033sublimes
subline9316893subline
sublines10315783sublines
sublots92410913sublots
submiss1138083submiss
submits1139753submits
sullies74122233sullies
susliks1136443susliks
tublike1337083tublike
tubulins10106293tubulins
tulips8137253tu_lips
tunics83811263tu_nics
uglies7412323_uglies
upboils1184703upboils

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.423422437.4
2DLD Change Limit1340271726.89019452.4
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.37624226.0
 
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.