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

194 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
pillions10161091(None) 
billions102211781billions
jillions15178271jillions
millions101712421millions
pillion92011691pillion_
zillions17168061zillions
billion92212162billion_
billons93013352bill_ons
bullions101710032bullions
cullions10219212cullions
hellions11310012hellions
jillion14188922jillion_
million91813132million_
mullions101910342mullions
pilling103722562pilli_ng
pillows122610102pill_ows
pinions93413602pi_nions
pulsions1037712pulsions
trillions947172trillions
zillion16188762zillion_
aiblins9311473aibli_ns
ailerons849833ailerons
antlions839193antlions
aphelions1474813aphelions
ballons93916953ball_ons
balloons103110503balloons
bazillions2143083bazillions
bilious9310933bi_lious
billies93923503billi_es
billing103823853billi_ng
billings113412633billings
billionth1444163billionth
billionths1553043billionths
billon83713823bill_on_
billows123611283bill_ows
bullion91911033bullion_
collins93419833colli_ns
cotillions1244773cotillions
cullion91910233cullion_
decillions1345413decillions
dictions111812673dictions
dilations102614453dilations
dillies84122153dilli_es
dilutions10248583dilutions
diluvions13224443diluvions
dislimns1144813dislimns
elisions82210423elisions
epilations12311713epilations
fictions132410743fictions
fillies103420253filli_es
filling113520803filli_ng
fillings122910503fillings
fillips12298133filli_ps
fillos94415073fill_o_s
fissions1138033fissions
galleons9258423galleons
galliots9228683galliots
gallons83015943gall_ons
galloons9289683galloons
gazillions2042693gazillions
gillies84120963gilli_es
gilling93520383gilli_ng
hellion10311133hellion_
hilling113821773hilli_ng
hilloas104413543hill_oas
hilloes103815943hill_oes
hilloing12158293hilloing
hillos94618883hill_o_s
hilltops1344913hilltops
illations9311393_illations
illites72415013_illites
illusions946213_illusions
inions64417003_i_nions
kazillions2352503kazillions
killicks1354873killicks
killies113318113killi_es
killing123118723killi_ng
killings133710483killings
killjoys2242023killjoys
kilotons1286303kilotons
lions55923213___lions
milliers102611893milliers
millimes122411373millimes
milline92519113milli_ne
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
milliohms1643663milliohms
millionth1444793millionth
millionths1543243millionths
millpond1344133millpond
millponds1443493millponds
millruns1043633millruns
minions93314623mi_nions
mirlitons1144113mirlitons
missions10311903missions
modillions1343673modillions
mullion91911173mullion_
nilling83619563nilli_ng
nonillions1045233nonillions
octillions1243603octillions
opinions1045933opi_nions
pactions122613503pactions
palling104024483palli_ng
palliums1236703palliums
pallors9314343pall_ors
papillons1344063papill_ons
passions10310583passions
paulins9312613pauli_ns
pavilions1444783pavilions
pavillons1443543pavill_ons
pelotons1038913pelotons
pensions10311693pensions
pereions10310853pereions
picolins1239853picoli_ns
pidgins11259123pidgi_ns
pigeons1039183pi_geons
piggins113010473piggi_ns
pileous9510523pi_leous
piling95025593pi_li_ng
pilings103313613pi_lings
pilis75825203pi_li__s
pillages113012603pillages
pillars9313483pill_ars
pillbox1843403pillbo_x
pillboxes2053343pillboxes
pillory12247443pill_ory
pillow113110573pill_o_w
pillowy15316423pill_owy
pills74130973pill___s
pilots84018873pi_l_ots
pilous84717753pi_l_ous
pinion83815893pi_nion_
pinons86019943pi__nons
pinyons12299003pi_nyons
pions75826393p___ions
pipkins15328183pipki_ns
pippins10319753pippi_ns
pistons93016373pi_stons
pitons85319043pi__tons
plains85019593p_lai_ns
pleons84213343p__leons
plosions1038023plosions
plutons938343p_lutons
polarons1039863polarons
polios84019723p_olio_s
pollens93713303poll_ens
pollices12410753pollices
polling102920383polli_ng
pollists10910823pollists
polliwogs1542093polliwogs
pollutions1245423pollutions
polygons1447723polygons
poplins11313153popli_ns
portions10514393portions
postillions1354543postillions
potions93417423p_otions
prilling113413413prilli_ng
prions84317783p__rions
pulling103821073pulli_ng
pullmans1253933pullmans
pulsion938393pulsion_
purlins93415423purli_ns
purloins1077033purloins
pylons113011243p_yl_ons
rilling84023623rilli_ng
scallions1145773scallions
scullions1154673scullions
septillions1352713septillions
silicons10107143silicons
sillies73425073silli_es
simlins9311823simli_ns
sirloins836713sirloins
solions7513743_solions
spillikins1651983spillikins
spilling113113933spilli_ng
stallions946063stallions
talions7314093_talions
tiglons837333tigl_ons
tilling83522773tilli_ng
tillites8312823tillites
trillion847963trillion_
vibrions1345093vibrions
villains1137993villains
villeins1136033villeins
villous102810013vill_ous
violins10311453violi_ns
virions1039873vi_rions
visions10311023vi_sions
willies103920153willi_es
willing113821613willi_ng
willows13299743will_ows
zillionth2152703zillionth

Search took 9 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.1561145455.1
2DLD Change Limit1461621948.01618233.8
3Display Results1941940.0762552.6
 (SQL Overall)1786911948.24821664.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.