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

143 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
tidbits103518(None) 
tidbit938491tidbit_
titbits935801titbits
tibias839952ti_bias
tidies74721832tid_ies
titbit839822titbit_
turbits969232turbits
adits66523713_ad_its
admits9411413_admits
ambits103713413_ambits
audits72814113aud_its
bedsits1037563bedsits
biddies113514493biddies
bidets95215533bid_ets
bidis86721143bid_i_s
bilbies114712343bilbies
binits85716673bi_nits
bits66148163___bits
cubits103714033_cubits
debits94214503_debits
didacts1186063didacts
didies84621833did_ies
digits84114533di_gits
dimwits1344513dimwits
dits56450523__d_its
dixits144210313di_xits
doits66223673__doits
duits65021883__duits
edits65819033_ed_its
fideist1139753fideist
fideists1245543fideists
fidgets12388763fidgets
gambits12399723gambits
gibbets12417723gibbets
giddies103713363giddies
gigabits1243533gigabits
godwits1234133godwits
habits113014653_habits
henbits12177003henbits
hobbits14317553hobbits
ibis66519583_i_bi_s
idiots768643_idiots
kibbis14398473kibbi_s
kibbitz2443953kibbitz
kibitz2177643ki_bitz
kiddies133412283kiddies
kidvids1643113kidvids
kilobits14124833kilobits
limits82514143li_mits
midairs1037203midairs
middies113116153middies
midgets113910253midgets
midguts11296013midguts
midis85923413mid_i_s
midlist10312513midlist
midlists1137523midlists
midribs1235513midribs
midsts95510053mid_sts
misbias1139083misbias
misfits12279663misfits
mishits122513083mishits
nidgets9358143nidgets
niobite937953niobite
niobites1037313niobites
nitwits1035053nitwits
obits74617553__obits
orbits84211443_orbits
pidgins11259123pidgins
pipits104713063pi_pits
probits112712573probits
qubits173710353_qubits
rabbits11299863rabbits
redbaits1135903redbaits
ridgils9326573ridgils
stilbite1045423stilbite
stilbites1144833stilbites
tabbies112913503tabbies
tabbis102910863tabbi_s
tallits73215993tallits
teddies92711283teddies
terbias9310743terbias
territs72714503territs
tibia7312403ti_bi_a
tibiae838483ti_biae
tibial849843ti_bial
tickets134113683tickets
tiderips1145383tiderips
tides64830153tid__es
tidied83613273tid_ied
tidier73515113tid_ier
tidiers8389773tidiers
tidiest83514873tid_iest
tidily102811393tid_ily
tiding83520093tid_ing
tidings93810263tidings
tidying1238513tidying
tidytips1441683tidytips
tiepins939463tiepins
tiffins13327983tiffins
tights104015853ti_ghts
tikis95615973ti_ki_s
tillite7313563tillite
tillites8312833tillites
tilts55325613ti__lts
timbals11239533timbals
timbers113111853timbers
timbres11249353timbres
tincts84510803ti_ncts
tineids8337873tineids
tinnitus843783tinnitus
tints56030923ti__nts
tipcats1137103tipcats
tipis76019923ti_pi_s
tippets11339373tippets
titis56023813ti_ti_s
titlist7312923titlist
titlists837293titlists
tits46145043t___its
titties73617363titties
tizzies15287893tizzies
tobies84521023t_obies
toddies93011993toddies
todies74223553tod_ies
toits55327473t__oits
tomtits937243tomtits
traits65121983t_raits
tridents938583tridents
trilbies1037693trilbies
tubist83013163t_ubist
tubists9288323t_ubists
turbit8715113turbit_
turbith1267113turbith
turbiths1374083turbiths
turbots988023turbots
twibils1253113twibils
twits86015793t__wits
vibist11610583vi_bist
vibists1256483vi_bists
viduity1445343viduity
visits9311423vi_sits
widdies123514033widdies
widgets12318453widgets
zibets1737743zi_bets

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.436409841.7
2DLD Change Limit1340271437.17018692.7
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.66923300.4
 
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.