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

156 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
bandito10371004(None) 
bandit93821131bandit_
banditos11347631banditos
bandits103814791bandits
bandied114414302bandied
bandies104124862bandies
banding114921412banding
banditry1444122banditry
banditti1143872banditti
bankit123617042bankit_
bankits133410152bankits
bonito8313432bon_ito
manito8518692man_ito
pandit93820752pandit_
pandits103914212pandits
adit56443653_a_dit_
adits66523713_a_dits
anatto6139913_anatto
andiron848283_andiron
andro6314163_and_ro
audio62917103_audi_o
audit62527883_audit_
auditor837313_auditor
audits72814113_audits
babbitt1038033babbitt
baddie104114033baddi_e
baddies114017873baddies
bagnio937523bagni_o
bait66556003ba__it_
baith108023133ba__ith
baits76630583ba__its
baldies105317703baldies
balding114015063balding
baldish1339503baldish
bambino1336483bambino
banality1338763banality
banco94019393ban__co
band76740923band___
banda85223113band__a
bandage11311023bandage
bandaid11310483bandaid
bandana10179463bandana
bandas95120543band_as
bandbox1943763bandbox
bandeau1038523bandeau
banded105223173band_ed
bander93928223band_er
banderol1145853banderol
banders104324563banders
bandicoot1453903bandicoot
bandmate1347973bandmate
bandog1038723band_og
bandogs1138363bandogs
bandora1038813bandora
bandore10611633bandore
bands85233433band__s
bandsaw1334803bandsaw
bandwidth1951743bandwidth
bandy114824193band__y
bandying15218073bandying
banging114019863banging
bani65334963ban_i__
banian8315383ban_ian
baning95127833ban_ing
banish111416053ban_ish
banjo143812443ban__jo
banking144621353banking
bannet84925333bannet_
bannets94013843bannets
banning103818233banning
banties94324763banties
banty106624003ban__ty
bardic11312923bardi_c
barding113822893barding
barite84224813ba_rite
barrio8312583barri_o
bauxite1635573bauxite
bawdier13378203bawdier
bawdies134613393bawdies
bawdily1635803bawdily
bendier103111413bendier
bending114420893bending
bento75922953ben__to
bindi85617013bindi__
binding113819383binding
bindis94614583bindi_s
binit76431583bin_it_
binits85716673bin_its
blandish1497003blandish
bonding113318433bonding
boniato947283boniato
bonita8312943bon_ita
bonitos939733bon_itos
brandied1259113brandied
brandies11714563brandies
branding122513683branding
brandish1469023brandish
bundist10310193bundist
bundists1145383bundists
bundt85824853bund_t_
bundts95010843bund_ts
burrito936223burrito
candid104517853candi_d
candida114110253candida
candids113812693candids
candied113816023candied
candies104125613candies
canto74931013can__to
cardio9915673cardi_o
dandier93714573dandier
dandies94121443dandies
dandify15245673dandify
dandily12279633dandily
danio6319783dan_i_o
endite73817593_endite
finito9310303fin_ito
hadith13312063ha_dith
handier113817443handier
handily143610873handily
handing123518893handing
indigo8388023_indigo
indite73520323_indite
janitor1436483jan_itor
ladino73615123la_dino
landing92819323landing
mandate10315573mandate
mandator1148183mandator
manitos9314053man_itos
manitou938463man_itou
manitu8315823man_itu
mannite9312903mannite
mannitol1044043mannitol
mendigo11506333mendigo
nandin7313033nandi_n
nandina838913nandina
nandins8312003nandins
pandied113913443pandied
pandies104224503pandies
panino8315683pan_ino
panto76129413pan__to
pundit92914183pundit_
pundits10379293pundits
radio64922493ra_di_o
randier83618473randier
randies84225663randies
sandier84017843sandier
sanding93520603sanding
sandlot8311693sandlot
sandpit1049633sandpit_
sandpits1146843sandpits
sanity9316203san_ity
santo56227283san__to
tanto55724953tan__to
vanity12311933van_ity
wendigo12845403wendigo
windigo12415953windigo

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.410435831.7
2DLD Change Limit1340271566.84319586.0
3Display Results1561560.0602600.0
 (SQL Overall)1786911567.31324434.7
 
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.