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

251 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
unbilled118869(None) 
unfilled1298381unfilled
unmilled1197851unmilled
untilled9710561untilled
unwilled1277821unwilled
anvilled1236482anvilled
billed94224902__billed
nilled73919452_n_illed
rebilled11318052rebilled
umbelled1336272umbelled
unbaled103315962unb_aled
unbelted1179332unbelted
unbiased1147152unbiased
unbitted1138212unbitted
unboiled112410372unboiled
unbolted1179322unbolted
unbridled1344972unbridled
uncalled11810922uncalled
unchilled1545562unchilled
undrilled1146662undrilled
undulled1036992undulled
unfilmed1495802unfilmed
ungalled1078452ungalled
unoiled82415472unoi_led
unpiled102312742unpi_led
unpolled1168942unpolled
unrifled1237422unrifled
unrolled9610412unrolled
unskilled1444602unskilled
unspilled1245092unspilled
untilted9610892untilted
untitled978762untitled
untwilled1343872untwilled
unwalled1288652unwalled
annulled944833annulled
anviled1138943anvi_led
balled94926893__balled
belled94626183__belled
bilged105513183__bilged
bilked134012943__bilked
biller84923483__biller
billet86029723__billet
birled94416993__birled
bolled94722653__bolled
brailled1147193brailled
bulled94626493__bulled
caballed1337163caballed
cavilled1436733cavilled
chilled133310933_chilled
devilled1336743devilled
dilled84122223__dilled
drilled94711673_drilled
engilded1143983engilded
enisled82510223en_isled
enrolled967963enrolled
ensiled82611433ensi_led
entitled967503entitled
filled104922263__filled
frilled113911603_frilled
fulfilled1642693fulfilled
funnelled1374233funnelled
gabelled12317583gabelled
gilled84521633__gilled
grilled94012833_grilled
hilled104022223__hilled
instilled1045293instilled
intitled967343intitled
inwalled1275773inwalled
killed113918773__killed
knelled12338983kn_elled
knolled12296563kn_olled
labelled11278293labelled
libelled11317213libelled
milled94326173__milled
misbilled1445173misbilled
nailed74021493_nai_led
nibbled12389073_nibbled
nubile83212713nubi_le_
nulled74318273_n_ulled
outkilled1444753outkilled
outwilled1345013outwilled
pencilled1445633pencilled
perilled11410093perilled
pilled94222753__pilled
pinballed1444033pinballed
prebilled1445063prebilled
prilled104712993_prilled
quilled17329283_quilled
rebelled113110323rebelled
refilled12278673refilled
rilled74525653__rilled
shilled113313623_shilled
shrilled1246863shrilled
skilled123110863_skilled
snailed83811923snai_led
snelled83313043sn_elled
spilled103613623_spilled
stilled83314773_stilled
swilled113611833_swilled
thrilled1235493thrilled
tilled74722953__tilled
trilled84116313_trilled
tunnelled1054583tunnelled
twilled11398033_twilled
umbeled12208193umb_eled
umbellet1247073umbellet
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unallied938393unallied
unaneled939793unaneled
unbacked17268733unbacked
unbaked143312893unb_aked
unbale83616403unb_ale_
unbales92914863unb_ales
unbanded123010563unbanded
unbanned11279113unbanned
unbarbed13217753unbarbed
unbarred11238703unbarred
unbased103513483unb_ased
unbasted112510073unbasted
unbated103317733unb_ated
unbathed1437223unbathed
unbeared111611653unbeared
unbelief1346773unbelief
unbeloved1543923unbeloved
unbended12279973unbended
unbiassed1243553unbiassed
unbid83214643unbi___d
unbidden1263573unbidden
unbigoted1343993unbigoted
unbind93011433unbi__nd
unbitten1045213unbitten
unbitter1046173unbitter
unblamed1337193unblamed
unblinded13295233unblinded
unbobbed1234413unbobbed
unbodied1237263unbodied
unbonded12299763unbonded
unboned103014223unb_oned
unbooted1188773unbooted
unbottled1244153unbottled
unbowed132610243unb_owed
unboxed17249573unb_oxed
unbraced132310433unbraced
unbraked15289413unbraked
unbred92613303unb__red
unbridged1453923unbridged
unbridle1145393unbridle_
unbridles1244133unbridles
unbriefed1553523unbriefed
unbroiled1235803unbroiled
unbuckled1843633unbuckled
unbuild1035723unbuil_d
unbundled1344103unbundled
unburied11208513unburied
unburned11227413unburned
unbusted11258773unbusted
uncoiled112512683uncoiled
uncooled112710633uncooled
uncurled1168963uncurled
undiluted1144903undiluted
undimmed1434113undimmed
unfallen1144463unfallen
unfelted1279403unfelted
unfired112212453unfi_red
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unfoiled12249723unfoiled
unfolded1338313unfolded
unfurled1277203unfurled
ungelded1147403ungelded
ungifted13116833ungifted
ungirded1136083ungirded
unglued937303un_glued
unhailed12219963unhailed
unhalved1556513unhalved
unhealed121511073unhealed
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257473unhinged
unhired112512153unhi_red
unified112413573un_ified
unilobed1136393un_ilobed
united74421543un_i_ted
unkeeled13117183unkeeled
unkindled1594203unkindled
unkinked12215903unkinked
unkissed1334893unkissed
unled64021073un___led
unlicked15248263unlicked
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmailed11229763unmailed
unmelted1169183unmelted
unmined102612953unmi_ned
unmingled1344283unmingled
unmitred1136843unmitred
unmixed17228213unmi_xed
unmolded1237453unmolded
unnailed9229443unnailed
unpeeled11118533unpeeled
unpicked17237213unpicked
unpile81914323unpi_le_
unpiles92112783unpi_les
unpinned1136383unpinned
unpitied1138783unpitied
unpitted1148623unpitted
unquelled1944413unquelled
unreeled91310333unreeled
unribbed1334173unribbed
unriddled1243813unriddled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unrivaled1345243unrivaled
unrivalled1443243unrivalled
unruled8311373un_ruled
unsalted9510923unsalted
unscaled111410113unscaled
unsealed91513623unsealed
unshelled1336563unshelled
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unsliced1138093unsliced
unsoiled92412083unsoiled
unsolved1237833unsolved
unsullied1044543unsullied
untidied1038893untidied
untied73720813unti__ed
untimed102713363unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
unvalued1266313unvalued
unveiled1298163unveiled
unwelded1337133unwelded
unwished15237833unwished
unwitted1237543unwitted
unzipped2233213unzipped
upboiled13194853upboiled
uppiled12216593uppi_led
uptilted1174673uptilted
upwelled1434663upwelled
willed104722453__willed

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.1731032896.0
2DLD Change Limit1461622517.61019206.6
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.87622688.0
 
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.