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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

228 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
flits8562522(None) 
fits76043471f_its
flats86429741flats
flics105418361flics
flies85630711flies
flints95617451flints
flips105117741flips
flirs85518931flirs
flirts95411481flirts
flit76539271flit_
flite85424961flite
flites95122441flites
frits86129101frits
lits46252501_lits
slits56128851slits
adits66523712adits
afrits9311902afrits
aits46355542_aits
alias55834602alias
alifs86121262alifs
alist56136782alist
alit46155692alit_
alts46639902al_ts
baits76630582baits
bits66148172_bits
blats75132502blats
blets75324942blets
blips95615782blips
bliss75616912bliss
blite76225352blite
blites84721212blites
blitz165318132blitz
blots75626172blots
brits76433082brits
chits105424572chits
clifts11519152clifts
clips96018302clips
clots75627642clots
crits75527572crits
dits56450532_dits
doits66223672doits
duits65021882duits
edits65819032edits
elints65816422elints
elite56230182elite
elites66027122elites
emits75421472emits
exits125515912exits
facts107021892facts
fails85631482fails
faints94818782faints
fairs85825442fairs
faith115620852faith
faiths124610272faiths
farts88336842farts
fasts86429682fasts
fats76252502f_ats
feats86432752feats
feints94813872feints
feist86230072feist
feists94915312feists
felids103111622felids
felts85324542felts
fests85828042fests
fets75345942f_ets
fiats85324482fiats
fibs96329512f_ibs
fids87034752f_ids
figs85332652f_igs
files85441272files
filets94718952filets
fills84632372fills
films105617962films
filos86125382filos
fils75838702f_ils
filth115015822filth
filths12389782filths
fins75849102f_ins
firs76637722f_irs
fist76248432f_ist
fists85527542fists
fit66365462f_it_
flabs105818642flabs
flags95321282flags
flails94313002flails
flairs95711912flairs
flams105125012flams
flans85327972flans
flaps105621382flaps
flat77147822flat_
flatus94310782flatus
flaws115920342flaws
flays116321052flays
fleas86423662fleas
flees85828752flees
fleets96915062fleets
flews115316442flews
fleys117015602fleys
flic96223732fli_c
flick145017212flick
flicks154512992flicks
flied96519432flied
flier86023402flier
fliers94417192fliers
fliest94718432fliest
flights143310982flights
flimsy14345562flimsy
fling97023512fling
flings106715282flings
flint87333502flint
flinty126112492flinty
flip96324262fli_p
flir76422202fli_r
flirt87424752flirt
flirty12499142flirty
flitch14928172flitch
flited104616582flited
floats96816252floats
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flops105920142flops
floss85118262floss
flota85315642flota
flotas94013002flotas
flouts94315272flouts
flows115822362flows
flubs105515442flubs
flues84626922flues
fluids10349422fluids
flus75626542fl_us
flute86823752flute
flutes95421782flutes
fluty114415642fluty
fluyts12367152fluyts
flyte115713942flyte
flytes123911562flytes
foils85025812foils
foins85523382foins
foist85730972foist
foists95413982foists
folios93915462folios
fonts86124752fonts
foots85528282foots
forts86034452forts
frats86829672frats
frets85523402frets
fries85535602fries
frigs96019272frigs
frit77044472frit_
frites94922482frites
frith115922032frith
friths124313582friths
fritt86129412fritt
fritts94613192fritts
fritz176020772fritz
fruits94512492fruits
gaits65726012gaits
gilts64924262gilts
gits55744602_gits
glias64618492glias
glims87417672glims
glints75714212glints
glitz154916372glitz
gluts66120132gluts
grits65529582grits
hilts86924412hilts
hits75545142_hits
its35538842__its
jilts124717412jilts
kilts95122192kilts
kits86441782_kits
kliks8398832kliks
knits93914752knits
lats45962702_lats
lets47147942_lets
libs66732772_libs
lids56336472_lids
lies46454202_lies
lifts85719062_lifts
lilts55822802_lilts
lins47059062_lins
lints57137192_lints
lips67141452_lips
lis37162282_li_s
list47055352_list
lists56628692_lists
lit39377322_lit_
litas54923772_litas
lite47054552_lite
litu47631572_litu
lots47652092_lots
milts75430712milts
nits45741652_nits
obits74617552obits
olios54520852olios
omits75018262omits
pits66348752_pits
plaits83816472plaits
plats75531372plats
plies74526512plies
plots75025672plots
quits144122352quits
shits84731172shits
silts55330822silts
sits45050212_sits
skits94721872skits
slats55436902slats
slims75423652slims
slips76023722slips
slit46250102slit_
slots54830532slots
sluts54523982sluts
snits54124832snits
spits74429552spits
splits85416412splits
suits55028052suits
tilts55325612tilts
tits46145052_tits
toits55327472toits
twits86015792twits
units54923432units
waits88333522waits
whits115923822whits
wilts85023502wilts
wits76044882_wits
writs86624382writs
zits136030302_zits

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538002281.64032804.9
3Display Results2282280.0603800.0
 (SQL Overall)1786912282.03088025.1
 
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.