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 “hobnobs” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
hobnobs144360(None) 
hobnob1335131hobnob_
haboobs1495462haboobs
hoboes114717442hob_oes
hobos106321352hob_o_s
honors94816792ho_nors
blobs95620033__blobs
bobs86340653__b_obs
bonbons1139333bonbons
bonobo1037143bo_nobo
bonobos1136393bo_nobos
boobs96221993__boobs
cabobs124311893cab_obs
cobbs115013993cob__bs
cobnuts1135353cobnuts
cobwebs1631933cobwebs
corncobs1444723corncobs
doblons1037043doblons
dobros93910233dobro_s
dobsons1036203dobsons
donors75115793do_nors
goboes95914443gob_oes
gobos86219383gob_o_s
gonofs10459863go_nofs
haboob1377883haboob_
heinous1038853heinous
hobbers143512343hobbers
hobbies143813343hobbies
hobbits14317553hobbits
hobbles143313783hobbles
hobby155913733hob__by
hobnail1243973hobnail
hobnails1343303hobnails
hobnobbed1651123hobnobbed
hobnobber1551173hobnobber
hobnobbers1651123hobnobbers
hobo97026083hob_o__
hoboed124511683hob_oed
hoboism1446623hob_oism
hobs97038983h___obs
hognose11117243hognose
hognoses12108133hognoses
hognuts1134183hognuts
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
hommos13128503hommo_s
homos105921783ho_mo_s
honans94814503ho_nans
hondas10313353ho_ndas
honers94324973ho_ners
hones88144493ho_n_es
honeys124016083ho_neys
hongs95126203ho_n_gs
honks125124523ho_n_ks
honor85718623ho_no_r
honour94710863ho_nour
honours10339373ho_nours
hons77350783ho_n__s
hoodoos11109293hoodoos
hoods95124083ho__ods
hoofs115721043ho__ofs
hooks125027123ho__oks
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoops105621073ho__ops
hoots84830253ho__ots
hornets104113553hornets
horns86125333horn__s
horrors1078693horrors
hotdogs1234453hotdogs
hotness1038613hotness
hotrods1148283hotrods
hounds104413133houn_ds
hubbubs1342603hubbubs
kabobs14439303kab_obs
kebobs14427293keb_obs
knobs11519713__knobs
kobos115616893kob_o_s
lobos75921843lob_o_s
monos75930863mo_no_s
nabobs10388213nab_obs
nobs66436903___nobs
oboes75717713_ob_oes
obols73715863_ob_ols
onos46229003_o_no_s
phonons123310253pho_nons
phonos114114793pho_no_s
poboys1397313pob_oys
pornos85015253porno_s
robots8313153rob_ots
snobs74716153__snobs
yobboes1445583yobboes
yobbos1335963yobbo_s

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.393454684.5
2DLD Change Limit134027966.70319995.1
3Display Results96960.0303200.0
 (SQL Overall)178691967.12625075.9
 
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.