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

132 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
jillions1517828(None) 
billions102211791billions
jillion14188931jillion_
millions101712431millions
pillions101610921pillions
zillions17168071zillions
billion92212172billion_
billons93013362bill_ons
bullions101710042bullions
cullions10219222cullions
hellions11310022hellions
million91813142million_
mullions101910352mullions
pillion92011702pillion_
trillions947182trillions
zillion16188772zillion_
aiblins9311473aibli_ns
ailerons849853ailerons
antlions839193antlions
ballons93916963ball_ons
balloons103110523balloons
bazillions2143093bazillions
bilious9310933bi_lious
billies93923503billi_es
billing103823853billi_ng
billings113412633billings
billionth1444163billionth
billionths1553043billionths
billon83713833bill_on_
billows123611293bill_ows
bullion91911033bullion_
collins93419833colli_ns
cotillions1244783cotillions
cullion91910233cullion_
decillions1345433decillions
dictions111812673dictions
dilations102614453dilations
dillies84122163dilli_es
dilutions10248583dilutions
diluvions13224443diluvions
dislimns1144813dislimns
elisions82210423elisions
fictions132410743fictions
fillies103420253filli_es
filling113520803filli_ng
fillings122910503fillings
fillips12298133filli_ps
fillos94415083fill_o_s
fissions1138033fissions
galleons9258443galleons
galliots9228683galliots
gallons83015953gall_ons
galloons9289703galloons
gazillions2042703gazillions
gillies84120963gilli_es
gilling93520383gilli_ng
hellion10311133hellion_
hilling113821773hilli_ng
hilloas104413553hill_oas
hilloes103815963hill_oes
hilloing12158303hilloing
hillos94618893hill_o_s
hilltops1344933hilltops
illations9311393_illations
illites72415013_illites
illusions946213_illusions
inions64417003_i_nions
jellies143816533jelli_es
jelling153516613jelli_ng
jellos134714283jell_o_s
jills125122823jill___s
jilting153211743jilti_ng
jolliers15357433jolliers
jollies143516273jolli_es
kazillions2352513kazillions
killicks1354873killicks
killies113318113killi_es
killing123118723killi_ng
killings133710483killings
killjoys2242033killjoys
kilotons1286313kilotons
lions55923213___lions
milliers102611903milliers
millimes122411373millimes
milline92519113milli_ne
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
milliohms1643673milliohms
millionth1444793millionth
millionths1543243millionths
millpond1344143millpond
millponds1443503millponds
millruns1043643millruns
minions93314623mi_nions
mirlitons1144113mirlitons
missions10311903missions
modillions1343683modillions
mullion91911173mullion_
nilling83619563nilli_ng
nonillions1045263nonillions
octillions1243613octillions
pilling103722563pilli_ng
pillows122610123pill_ows
pinions93413603pi_nions
pulsions1037713pulsions
rilling84023623rilli_ng
scallions1145783scallions
scullions1154683scullions
silicons10107163silicons
sillies73425083silli_es
simlins9311843simli_ns
sirloins836723sirloins
solions7513753_solions
stallions946073stallions
talions7314113_talions
tiglons837343tigl_ons
tilling83522783tilli_ng
tillites8312833tillites
trillion847973trillion_
vibrions1345093vibrions
villains1138003villains
villeins1136043villeins
villous102810023vill_ous
violins10311453violi_ns
virions1039873vi_rions
visions10311023vi_sions
willies103920153willi_es
willing113821613willi_ng
willows13299753will_ows
zillionth2152703zillionth

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.1561145455.1
2DLD Change Limit1461621327.40619735.6
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.60823487.3
 
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.