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

151 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
titbits93580(None) 
tidbits1035181tidbits
titbit839821titbit_
nitwits1035052nitwits
tibias839952ti_bias
tidbit938492tidbit_
titis56023812tit_i_s
titlist7312922titlist
titlists837292titlists
titties73617362titties
turbits969232turbits
ambits103713413_ambits
attrits7310623attrits
bilbies114712343bilbies
binits85716673bi_nits
bits66148173___bits
bitts75022593bit__ts
cities84524853cit_ies
citrins92614363citrins
cubits103714033_cubits
debits94214503_debits
digits84114533di_gits
dimwits1344513dimwits
ditties83116983ditties
dixits144210313di_xits
gambits12399723gambits
gibbets12417723gibbets
gigabits1243533gigabits
habits113014653_habits
henbits12177003henbits
hobbits14317553hobbits
ibis66519583_i_bi_s
intuits7310313intuits
kibbis14398473kibbi_s
kibbitz2443953kibbitz
kibitz2177643ki_bitz
kilobits14124833kilobits
kitbags1443883kitbags
kitties113213623kitties
limits82514143li_mits
lithias1038823lithias
misbias1139083misbias
misfits12279663misfits
mishits122513083mishits
mitis75425993mit_i_s
mitts75523753mit__ts
niobite937953niobite
niobites1037313niobites
nitrids8269633nitrids
nitrils72810703nitrils
nitrite72314463nitrite
nitrites82313453nitrites
nitwit938593nitwit_
obits74617553__obits
orbits84211443_orbits
otitis63612343otit_i_s
outbids1098913outbids
outfits102210833outfits
outhits102213503outhits
outsits73215253outsits
outwits103110863outwits
pipits104713063pi_pits
pities83828083pit_ies
probits112712573probits
qubits173710353_qubits
rabbits11299863rabbits
stilbite1045423stilbite
stilbites1144833stilbites
stithies1139233stithies
tabbies112913503tabbies
tabbis102910863tabbi_s
tallits73215993tallits
tatties74120343tatties
terbias9310743terbias
territs72714503territs
tetris62816293tetri_s
tibia7312403ti_bi_a
tibiae838483ti_biae
tibial849843ti_bial
tickets134113683tickets
tidies74721833ti_dies
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
titanias847103titanias
titanite898433titanite
titanites997413titanites
titans63414913tit_ans
titers64526413tit_ers
titfers10318933titfers
tithers104216733tithers
tithes94720213tit_hes
tithing113513893tithing
tithings12327693tithings
titi47130633tit_i__
titian62512663tit_ian
titians72710453titians
titles63719923tit_les
titling83715793titling
titmice1144663titmice
titrants838483titrants
titrate72215573titrate
titrates82314663titrates
titres64718933tit_res
tits46145053__t_its
titters74219623titters
tittie63213153titti_e
tittles73413253tittles
tittups933353tittups
titty85316653tit__ty
tizzies15287893tizzies
tobies84521023t_obies
toits55327473__toits
tomtits937243tomtits
traits65121983t_raits
trilbies1037693trilbies
tubist83013163t_ubist
tubists9288323t_ubists
turbit8715113turbit_
turbith1267113turbith
turbiths1374083turbiths
turbots988023turbots
tutties73216473tutties
tuttis63611373tutti_s
twibils1253113twibils
twits86015793__twits
tzitzis1542423tzitzi_s
tzitzit1542703tzitzit_
tzitzith1951863tzitzith
vibist11610583vi_bist
vibists1256483vi_bists
visits9311423vi_sits
vitrics12198553vitrics
withies133913543withies
withins133511693withins
zibets1737743zi_bets
zitis145815583zit_i_s

Search took 7 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.423422437.4
2DLD Change Limit1340271516.26321399.8
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.73226543.5
 
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.