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

238 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
policies12241566(None) 
polices113118051polic_es
polities102722341polities
colicines13311202colicines
colicins12312852colicins
impolicies1644682impolicies
ploidies1138172ploidies
police102918562polic_e_
policed123212232polic_ed
policer113112682polic_er
policers12259992policers
policing13311672policing
polies84034582pol__ies
polishes13711782polishes
politics122513812politics
pollices12410752pollic_es
potiches1539202potiches
pulicides1446282pulicides
solicits10311022solicits
alibies9313323_alibies
allicins1049653allicins
apologies12311193apologies
boccies133311513bo_ccies
bodices12710593bodic_es
bolides10515073boli_des
bolivias1345393bolivias
bolshies1338693bolshies
calices114321693calic_es
caliches153812263caliches
calicles123811433calicles
calicoes123911593calicoes
cilices113814023cilic_es
cliches144213743_cliches
coalifies1439113coalifies
codices12512583codic_es
codicils1346043codicils
codifies1439643codifies
colicin11313743colici_n
colicine12312993colicine
colickier1743513colickier
colickiest1843523colickiest
colics104219903colic__s
colies84837053col__ies
colitis92617353coliti_s
colitises11311743colitises
collies94326583col_lies
colonies103620013colonies
comities12317793comities
culices113713123culic_es
culicids1345623culicids
culicines1347013culicines
cylices14359283cylic_es
doilies84017363do_ilies
dollies83620983dol_lies
domiciles1445423domiciles
domicils1345073domicils
dominies113513193dominies
elicits9311233_elicits
eolipiles1144483eolipiles
filicides1545943filicides
folacins1337203folacins
foliages1247623foliages
foliates11412753foliates
folkies143612253fol_kies
follicles1444103follicles
follies103618943fol_lies
helices12313723helic_es
holies94630033hol__ies
hollies103420813hol_lies
homicides1745853homicides
homilies132710113homilies
hominies133012953hominies
iolites73819483ioli_tes
jollies143516273jol_lies
jollifies1945553jollifies
jollities1647873jollities
liches114724293__liches
lilies63021413__lilies
logicise1146113logicise
logicises1256203logicises
logicizes2145933logicizes
lollies73116923lol_lies
malices114316623malic_es
modifies1439163modifies
molies84429513mol__ies
mollies93420233mol_lies
mollifies1447553mollifies
notices9312283notic_es
notifies11310423notifies
novices1238223novic_es
oldies7314423_ol_dies
olives94313953_oli_ves
olivines1137473_olivines
ologies8615023_ologies
oolites72817843ooli_tes
oologies9312993oologies
ovicides1445463_ovicides
pacifies15311223pacifies
palaces114216453palac_es
palsies94420273pal_sies
panicles121010113panicles
papacies1439473papacies
parities10522973parities
pedicles1338683pedicles
pelicans1238093pelicans
pelisses1048483pelisses
pelites93821993peli_tes
pellicles1344923pellicles
peltries10313023peltries
penicils1247863penicils
piosities11311723piosities
piracies12312643piracies
pities83828083p__ities
pixies154915513p__ixies
places104323703p_lac_es
plaices11411143plaic_es
platies93722543p_laties
pliancies1346673p_liancies
plicae10410953p_licae_
plies74526513p_l__ies
pliskies1475973p_liskies
plisses94411773p_lisses
plotties103111413plotties
poaches144416943po_aches
podites103014733podi_tes
poesies93217403po_esies
poeticizes2347133poeticizes
poetries10315583poetries
pogies94123543po__gies
pointes93216753po_intes
poises84226543po_i_ses
pokies125921333po__kies
polarise10513903polarise
polarises11514073polarises
polarities121211773polarities
polarizes20513023polarizes
poleaxes1767273poleaxes
polecats1248833polecats
poleis86018353pol_ei_s
polemicizes2654153polemicizes
polemics1448183polemics
polemizes2248153polemizes
poles75351003pol___es
policemen1543783policemen
policy133211513polic__y
polios84019723pol__ios
polis74731163pol__i_s
polished1468433polished
polisher1388073polisher
polishers1477603polishers
polite83625073poli_te_
politer92417073poli_ter
politest10312943poli_test
politic112918713politi_c
politicise1447243politicise
politicises1546903politicises
politicizes2445943politicizes
politick16289333politick
politicks17276843politicks
politico122510013politico
politicoes14265013politicoes
politicos13287083politicos
pollees93215333pol_lees
pollinizes2146953pollinizes
pollutes1037613pollutes
polycots1547763polycots
polyenes13510063polyenes
polyimides1844623polyimides
polypides1747073polypides
pomaces132712123pomac_es
pommies133712843po_mmies
ponces104720843po_nc_es
ponies84833463po__nies
pooches143214163po_oches
poperies12316793poperies
poppies102816193po_ppies
popsicles1543663popsicles
popsies112816463po_psies
porches143815673po_rches
porgies103017003po_rgies
porkies133416493po_rkies
porkpies1636193porkpies
porticoes1348253porticoes
posies84431433po__sies
positives1459173positives
postiches1648223postiches
posties93128813po_sties
potencies1369303potencies
potiche1438043potiche_
potlaches16115263potlaches
potlines10714213potli_nes
potpies113116173po_tpies
potsies93019483po_tsies
potties93723543po_tties
pouches144116743po_uches
poultices1345673poultic_es
poultries1148453poultries
pounces114113893pounc_es
poussies1038113poussies
prairies10411453prairies
prelacies13310053prelacies
prices104524543p_ric_es
pricier113313113p_ricier
priciest122112903p_riciest
privies122414263p_rivies
probities13312653probities
prodigies1346953prodigies
prolines102619693proli_nes
publicise1544223publicise
publicises1644243publicises
publicizes2544073publicizes
pulicide1347043pulicide
pumices1338273pumic_es
pumicites1545623pumicites
purifies13311923purifies
purities10316283purities
salicines11310003salicines
salicins10310933salicins
salifies11314793salifies
scolices1238733scolic_es
silicides1247073silicides
silicles1037073silicles
slices84022853_slic_es
solaces93116133solac_es
solecise1089073solecise
solecises1189103solecises
solecizes2087863solecizes
solicit9315743solici_t
solicited1247973solicited
splices113914383splic_es
spoliates1138543spoliates
sporicides1544443sporicides
tolidines1046883tolidines
tolidins948023tolidins
uglifies1246383uglifies
vilifies1439593vilifies
voices114414013vo_ic_es
voleries11313233voleries

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.423422437.4
2DLD Change Limit1461622386.58022213.1
3Display Results2382380.0932559.1
 (SQL Overall)1786912387.09625181.9
 
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.