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

103 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
flunk12501438(None) 
clunk114215081clunk
flank124618091flank
flung95114581flung
flunks13469861flunks
flunky16408091flunky
funk115825621f_unk
lunk86030721_lunk
plunk114514401plunk
slunk95016301slunk
blank115418552blank
blink115720142blink
blunt75525022blunt
bunk105731352_bunk
chunk144812382chunk
clank114719522clank
clink115320042clink
clonk114417442clonk
cluck134914892cluck
clung86013602clung
clunks124811012clunks
clunky15447892clunky
drunk10549842drunk
dunk96228572_dunk
faun76226622faun_
fauna84816512fauna
fauns84516752fauns
fink117532122f_ink
flack144519412flack
flak116026172fl_ak
flan76134182flan_
flanks133913402flanks
flans85327972flans
flask125512422flask
flaunt9712912flaunt
fleck148213592fleck
flick145017212flick
fling97023512fling
flint87333502flint
flock144717422flock
flong95815682flong
flu66530212flu__
flub95721882flu_b
flubs105515442flubs
flue75329852flu_e
flued95021252flued
fluent9313932fluent
flues84626922flues
fluff103913612fluff
fluid94013962fluid
fluke125016892fluke
fluky154512292fluky
flume106021172flume
flump124614722flump
flunked15398412flunked
flunker14389362flunker
flunkey17405792flunkey
flunkie1434512flunkie
fluor84512772fluor
flus75626542flu_s
flush115116072flush
flute86823752flute
fluty114415642fluty
flux145617742flu_x
fluyt114614202fluyt
found94917842found
fount84727032fount
frank124417512frank
fuck134924632f_uck
fun66841142f_un_
fund85624982f_und
funks125318912f_unks
funky154315132f_unky
funs75235732f_uns
gunk95423572_gunk
hunk116029542_hunk
junk155121032_junk
lank84734452_lank
link86943442_link
luck105329822_luck
luna46229852_luna
lune47140492_lune
lung55732492_lung
lunks94822452_lunks
lunt46148842_lunt
luny77324132_luny
lurk86624162_lurk
plank115221142plank
plink115219122plink
plonk114613982plonk
pluck134212302pluck
plunks124711162plunks
plunky15377952plunky
punk105729972_punk
skunk85011762skunk
slank95822772slank
slink95422912slink
slung65117832slung
spunk114513402spunk
stunk94616292stunk
sunk85031812_sunk
thunk124911852thunk
trunk94713042trunk

Search took 2 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.360496363.9
2DLD Change Limit538001031.54634799.5
3Display Results1031030.0333121.2
 (SQL Overall)1786911031.93992156.3
 
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.