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

115 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
bollixed183448(None) 
bollixes1747201bollixes
bolloxed1834471bolloxed
bellied104314072belli_ed
bolled94722652boll__ed
bollix1538052bollix__
bolloxes1736832bolloxes
bullied104514812bulli_ed
collided12309802collided
collied103316682colli_ed
dollied93811142dolli_ed
jollied15349272jolli_ed
allied74217153_alli_ed
balled94926893ball__ed
ballies93725743balli_es
balloted1189043balloted
beelined11277713beelined
belied95022163b_eli_ed
belled94626193bell__ed
bellies94023723belli_es
bellowed14158613bellowed
bemixed19337053b_emixed
beslimed1335013beslimed
billed94224903bill__ed
billeted1137643billeted
billiard1145873billiard
billie85019173billi_e_
billies93923503billi_es
billowed14137063billowed
bodied103814583bo_di_ed
boiled95020953bo__iled
bolide9515563bo_lide_
bolides10515073bo_lides
bollard103210503boll_ard
bolling103820883bolli_ng
bollixing1944813bollixing
bollox1548743bollox__
bolted94617803bo_l_ted
boltlike1436313boltlike_
boogied11379283boogi_ed
bowled125018143bowl__ed
bowlike16349473bowlike_
bowline123613113bowline_
bowlines133211623bowlines
bowllike1734863bowllike_
boxed154318613bo___xed
boxlike20267073boxlike_
brollies1039533brolli_es
bulled94626493bull__ed
bulleted1138393bulleted
bullier94116433bulli_er
bullies94121893bulli_es
bullweed1444753bullweed
bylined1335853b_ylined
collaged12279973collaged
collared113211143collared
collated113615063collated
colleted113011663colleted
collide103214793collide_
collider113410423collider
collides113214473collides
collie83621993colli_e_
collier93618153colli_er
collies94326583colli_es
colluded12296463colluded
commixed2264743commixed
cullied104012353culli_ed
dallied93713613dalli_ed
dolled83518073doll__ed
dollies83620983dolli_es
dolloped1234983dolloped
filliped1435223filliped
folioed1138033fo_lioed
follies103618943folli_es
followed15146273followed
gallied94115003galli_ed
gillied95512313gilli_ed
gullied93812063gulli_ed
hollaed11359853holl_aed
hollered1237603hollered
hollies103420813holli_es
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157033hollowed
jellied15419223jelli_ed
jollier142911003jolli_er
jollies143516273jolli_es
jollified2044303jollified
lolled74315823loll__ed
lollies73116923lolli_es
lolloped1134463lolloped
milliped1337383milliped
mollie83517103molli_e_
mollies93420233molli_es
mollified1545653mollified
obelised1136173obelised
obelized2036333obelized
obliged1134983_obliged
poleaxed1854823poleaxed
policed123212233po_liced
polled94022003poll__ed
pollened1157783pollened
pollices12410753pollices
polluted1135433polluted
rallied83514083ralli_ed
rolled74220243roll__ed
rollicked1643033rollicked
sallied83316953salli_ed
sullied83714483sulli_ed
tallied83314753talli_ed
tolled73819033toll__ed
trollied935903trolli_ed
volleyed1543533volleyed
willied114611563willi_ed

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.423422437.4
2DLD Change Limit1461621157.14020470.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.60923484.2
 
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.