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

182 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
pilus7592106(None) 
hilus84817641hilus
pilaus84114131pilaus
piles74742611piles
pileus84514941pileus
pilis75825201pilis
pills74130971pills
pilous84717751pilous
pious74621271pious
plus66324831p_lus
poilus82210571poilus
ails45654712ail_s
biles75542142biles
bilks115117892bilks
bills75632862bills
bolus79125542bolus
dills65530972dills
ficus105015492ficus
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
filum105015432filum
flus75626542_flus
gilds75417522gilds
gills64728192gills
gilts64924262gilts
hills85431352hills
hilts86924412hilts
hilum105514602hilum
iglus6609932iglus
ileus54616892_ileus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
lieus56218482lieus
lilos55821872lilos
lilts55822802lilts
lulus54315162lulus
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mil_s
milts75430712milts
minus75223932minus
nidus65913572nidus
nills54926672nills
nils46132452nil_s
nisus56014392nisus
oils46337972oil_s
pails75833062pail_s
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
palpus104210282palpus
pals66951352pal_s
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
peplus10138342peplus
pians75126962pians
pias66542552pi_as
picas94626522picas
picks135226142picks
pics85633912pi_cs
picul95015362picul
piculs103511752piculs
piers75926332piers
pies66949602pi_es
pignus937952pignus
pigs76634222pi_gs
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
pilaf103923482pilaf
pilafs113511022pilafs
pilar75221502pilar
pilau73618522pilau
pilaw103913742pilaw
pilaws11399432pilaws
pile65649692pil_e
pilea75123952pilea
piled85232992piled
pilei74021782pilei
pileous9510522pileous
pileum10399512pileum
pileup10437922pileup
pileups11365432pileups
pili66130352pil_i
pill65339462pil_l
pilose84514242pilose
pilot77435062pilot
pilots84018872pilots
pilule8411122pilule
pilules9510622pilules
pily96132732pil_y
pimas94725102pimas
pimps114616982pimps
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pi_ns
pints75936222pints
pinup9612882pinup
pinups1037412pinups
pions75826392pions
pipes96030142pipes
pips85837132pi_ps
pique16410172pique
piques1739092piques
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pitas77427672pitas
piths105817542piths
pits66348742pi_ts
piu56639542pi_u_
pixes144323172pixes
plies74526512plies
plug74915992p_lug
plugs85213492p_lugs
plum85122102p_lum
plums94619952p_lums
plush105614712p_lush
poilu72316002poilu_
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
praus74621752praus
prills84015612prills
primus103712172primus
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
pupus94614042pupus
pus55547842p__us
riles55343642riles
rills55032712rills
risus54216392risus
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
sinus55523852sinus
situs55019232situs
solus54726982solus
spiles84227912spiles
spills84717462spills
sulus54821882sulus
talus55423262talus
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
tolus55024482tolus
ulus45622562_ulus
vills86429322vills
villus93611222villus
virus85316842virus
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
yills83921552yills
zills144020782zills

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.296603685.8
2DLD Change Limit538001821.59333772.8
3Display Results1821820.0463956.5
 (SQL Overall)1786911821.93592346.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.