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 “polis” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

234 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
polis7473116(None) 
pilis75825201pilis
pois66539041po_is
poleis86018351poleis
poles75351001poles
polies84034581polies
polio75722551polio
polios84019721polios
polish114916721polish
polls74627721polls
polos76129911polos
pols66044561pol_s
polys105718761polys
pulis74225601pulis
aiolis6316842aiolis
boils75427192boils
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
coils75030082coils
colas75436772colas
colds85726972colds
coles76055062coles
colic95726172colic
colics104219902colics
colies84837052colies
colin76231692colin
colins85229042colins
cols66553082col_s
colts76633292colts
coulis84018762coulis
delis64928542delis
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
foils85025812foils
folds95221692folds
folia83618932folia
folic105319322folic
folio83820882folio
folios93915462folios
folks126017122folks
follis93113902follis
golds75421312golds
golfs95616102golfs
holds94623242holds
holes84748652holes
holies94630032holies
holism113713752holism
holist94723212holist
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
joles125230832joles
jolts125018882jolts
kois85129402ko_is
kojis16468442kojis
kolas94822232kolas
kolos94921212kolos
lis37162272__lis
lolls512121732lolls
loris55329152loris
louis57322322louis
moils76125752moils
molas75132092molas
molds85324832molds
moles74747922moles
molies84429512molies
molls75129782molls
mols65948572mol_s
molts76032092molts
noils55024332noils
nolos54423352nolos
noris54928272noris
obis66226842_obis
oils46337972_oils
olds55926572_olds
oles46453472_oles
olio46829672_olio
olios54520852_olios
padis86227142padis
pails75833062pails
palais8420422palais
pales75753802pales
palish114718272palish
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
paris75145942paris
pavis106422732pavis
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pelvis113610322pelvis
penis75129322penis
peris75537072peris
phis95724902p_his
pikis115116392pikis
piles74742612piles
pili66130352pili_
pills74130972pills
pilus75921062pilus
pis56362032p__is
plie65127392p_lie
plies74526512p_lies
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
plus66324832p_lus
pocks135022962pocks
podia8415282podia
pods76540152po_ds
poems95715552poems
poets76024442poets
pogies94123542pogies
poi57244662po_i_
poilu72316002poilu
poilus82210572poilus
poise75127892po_ise
pokes116133012pokes
pokies125921332pokies
pol56449382pol__
polar75623452polar
polars84419352polars
pole65951302pol_e
poled84934842poled
poler74431792poler
polers84225642polers
police102918562police
polices113118052polices
policy133211512policy
poling93526502poling
polite83625072polite
polity113015862polity
polka11310412polka
polkas1239102polkas
poll66332132pol_l
pollist9816602pollist
polo66236632pol_o
poloist91016322poloist
poly96235152pol_y
polyp125611532polyp
polyps13479762polyps
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
ponies84833462ponies
pons65850602po_ns
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
pooris83916842pooris
poos65949112po_os
popes95933812popes
popish133812112popish
poplin10413482poplin
poplins11313152poplins
pops86340952po_ps
pores75849032pores
porism104518062porism
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
posies84431432posies
posit75833332posit
posits85718712posits
posts75228782posts
pots66452362po_ts
poufs105616062poufs
poults84613482poults
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
proles84627202proles
prolix1538682prolix
psis68120342p_sis
ptosis83611822ptosis
pubis94616472pubis
pules74538812pules
puli65527622puli_
pulik113613302pulik
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
puris75332022puris
pyosis114012122pyosis
pyxis17458632pyxis
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotis56327062rotis
soils55327982soils
soles55547922soles
soli46637012soli_
solid65025082solid
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
spoils84614532spoils
sylis84316022sylis
toils54527492toils
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
topis76025832topis
voles86234042voles
volts85421292volts
wolds95420182wolds
wolfs116214162wolfs
yogis95617742yogis
yolks125412772yolks
yonis85020822yonis
zoris145320012zoris

Search took 2 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 Filter178691538000.0802233637.5
2DLD Change Limit538002341.67032215.6
3Display Results2342340.0633714.3
 (SQL Overall)1786912341.81398560.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.