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

139 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
bunkums154405(None) 
bunkum1435981bunkum_
bunkers133715952bunkers
bunkos124210322bunk_os
bunks115125082bunk__s
bupkus14385682bupku_s
cundums1235182cundums
dinkums1433672dinkums
ankus91410683_anku_s
aurums849383au_rums
backups1736173backups
bankers133919093bankers
bankits133410153bankits
banks115527903bank__s
bantams1149063bantams
bariums1139153bariums
begums11429493b_egums
benumb1235773ben_umb
benumbs1333543ben_umbs
bluegums1372963bluegums
bonducs1235553bonducs
bonkers134015303bonkers
bonks116326463bonk__s
bonus75324323bon_u_s
boojums1842653boojums
bubkes144612623bubk_es
bubus95115453bu_bu_s
buckers153517453buckers
buckets153811693buckets
buckles153416093buckles
buckoes153810393buckoes
buckos143710893buck_os
buckrams1844483buckrams
buckras1537343buckras
bucks134824293buck__s
bugouts1036193bugouts
bulbuls11346783bulbuls
bulgurs10397113bulgurs
bulks115920613bulk__s
bumkins15318013bumkins
bums85934593b___ums
bunas75126573bun__as
bunches144116033bunches
buncos104011593bun_cos
bundles103515773bundles
bunds85523543bun__ds
bundts95010843bun_dts
bungees104513103bungees
bungles104116763bungles
bungs85323863bun__gs
bunions92210473bunions
bunk105731353bunk___
bunked135118373bunk_ed
bunker124519373bunk_er
bunking144016193bunking
bunko115514513bunk__o
bunkoed14356663bunkoed
bunnies94415003bunnies
bunns74718293bun__ns
bunrakus1441893bunraku_s
buns66243723bun___s
bunters94717123bunters
bunts75729803bun__ts
bunyas11359433bun_yas
bupkes144811483bupk_es
burkas124513803burk_as
burkers133716623burkers
burkes124421313burk_es
burnous938823burnou_s
burnouts1045263burnouts
buskers133414093buskers
buskins133310943buskins
busks115521373busk__s
bututs8409423bu_tuts
buyouts1235203buyouts
buzukis2242663buzukis
centums11398783centums
coniums11311863coniums
cundum1136513cundum_
cuprums1334453cuprums
curiums1138503curiums
dinkum1335893dinkum_
dubniums1343153dubniums
dumdums1343043dumdums
dunams937833dun_ams
dunkers123512193dunkers
dunks105621193dunk__s
durums948153du_rums
fanums1137263fan_ums
fuckups1832923fuckups
fundus10429173fundu_s
fungus10418183fungu_s
funkers143712063funkers
funkias1435383funkias
funks125318913funk__s
gunks104517723gunk__s
hokums1533923_hokums
hunkers143314333hunkers
hunkeys17386193hunkeys
hunkies143214503hunkies
hunks125321453hunk__s
ioniums938313ioniums
jugums16104673ju_gums
jukus16398673ju_ku_s
junkers184010863junkers
junkets18377623junkets
junkies183711693junkies
junks164815973junk__s
linkups1333633linkups
linums838283lin_ums
lunkers113414613lunkers
lunks94822453lunk__s
miniums113910223miniums
muoniums1244723muoniums
museums1134573museums
neums75414253__neums
oakums1264153_oakums
punkahs16284783punkahs
punkas123410673punk_as
punkers133714863punkers
punkeys16366493punkeys
punkies134216803punkies
punkins133111113punkins
punks114822683punk__s
quorums1843893quorums
ruckus12407793rucku_s
runkles114111943runkles
runouts737353runouts
subgums1235893subgums
sunkets113511283sunkets
sunups837263sun_ups
trinkums1443413trinkums
tuneups933333tuneups
unarms839243_unarms
unaus53216573_unau_s
uncus74014983_uncu_s
ungues7412123_ungues
unguis738453_unguis
unjams1555703_unjams

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271396.98619185.1
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.43824024.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.