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

167 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
filet8554016(None) 
file75446641file_
filed95331901filed
filer85433001filer
files85441271files
filets94718951filets
fillet95027081fillet
aglet65534142aglet
aiglet74224192aiglet
ailed66240282ailed
bidet84935622bidet
bile66147172bile_
biles75542142biles
billet86029722billet
blet66247672_blet
civet105828732civet
culet76040342culet
diet57357532di_et
facet106038522facet
failed105421602failed
feet75352212f_eet
felt75146932fel_t
fet66471632f__et
fiat76646642fi_at
fiber104921132fiber
fice95737112fice_
fices106031162fices
fidget114216472fidget
fie67152442fi_e_
fief107331352fi_ef
field95015322field
fife106027702fife_
fifed125115972fifed
fifer115519972fifer
fifes114822392fifes
fight124027092fight
fil65447142fil__
fila74729132fil_a
filar84819292filar
filbert12411642filbert
filch134813322filch
filemot1246702filemot
filers94623722filers
fileted1159092fileted
fill75540192fil_l
fille84327402fille
filled104922262filled
filler94623622filler
filles94224522filles
fillets103414752fillets
fillo84319782fillo
fills84632372fills
filly114424902filly
film94828172fil_m
filmed124610362filmed
filmer114112402filmer
filmi105914002filmi
films105617962films
filmset1257512filmset
filmy136114042filmy
filo76034282fil_o
filos86125382filos
fils75838692fil_s
filter94517632filter
filth115015822filth
filum105015432filum
fine75147952fine_
fined94930502fined
finer85431562finer
fines86644262fines
finest94321732finest
fire76245592fire_
fired94829742fired
firer811229252firer
fires85740752fires
first86226122first
fist76248422fi_st
fit66365452fi__t
five107629742five_
fiver116024942fiver
fives116027362fives
fixed165416952fixed
fixer154717832fixer
fixes154723592fixes
fixit154819302fixit
fixt1410729712fi_xt
flat77147822f_lat
flea75628492f_lea
fled85429772f_led
flee76238792f_lee
fleet85932332fleet
flew105824252f_lew
flex146123472f_lex
fley106626852f_ley
flied96519432flied
flier86023402flier
flies85630712flies
fliest94718422fliest
flint87333502flint
flirt87424752flirt
flit76539272f_lit
flite85424962flite
foiled104618402foiled
foley115222302foley
fret75845042f_ret
fumet105630222fumet
giblet93418892giblet
giglet83920272giglet
gilt56348542gil_t
gimlet93716662gimlet
hilt75850712hil_t
ilea45931462_ilea
ilex115822032_ilex
inlet53732402inlet
islet54527552islet
jilt115839422jil_t
kilt86144412kil_t
let36481472__let
lilt46349942lil_t
mile66352562mile_
miler75733062miler
miles74645072miles
millet84030742millet
milt65455802mil_t
oiled64429472oiled
oiler54628282oiler
owlet83324462owlet
palet74650802palet
piglet93420922piglet
pile65649692pile_
pilea75123952pilea
piled85232992piled
pilei74021782pilei
piles74742612piles
pilot77435062pilot
piolet83225642piolet
pipet95533322pipet
relet54749822relet
riblet84222442riblet
rile45650532rile_
riled65833252riled
riles55343642riles
riley84420582riley
rillet64828852rillet
rivet85636362rivet
silent64125842silent
silex123417412silex
silt46558192sil_t
tile45451442tile_
tiled64832942tiled
tiler56131022tiler
tiles55542102tiles
tilt46252422til_t
toilet66228092toilet
unlet54133332unlet
valet84337872valet
vile76139802vile_
viler86324162viler
vilest9416842vilest
violet92620922violet
wiglet105519152wiglet
wile75944372wile_
wiled95231552wiled
wiles85437872wiles
willet95124832willet
wilt76246292wil_t
zibet16419732zibet

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.186960704.3
2DLD Change Limit538001671.90628226.7
3Display Results1671670.0463630.4
 (SQL Overall)1786911672.13883578.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.