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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
flukes13511419(None) 
flakes134118871flakes
flues84626921flu_es
fluke125016891fluke_
fluked145112091fluked
flukey16459811flukey
flumes115119731flumes
flutes95421781flutes
fluxes165212931fluxes
blokes123813882blokes
blues75127042blu_es
blumes105917792blumes
clues74623032clu_es
cukes115422092_cukes
dukes105023472_dukes
eludes75417682eludes
elutes64020312elutes
fakes126032482f_akes
fauces114916152fauces
fauves125610422fauves
flake125119972flake_
flaked144715652flaked
flaker134916172flaker
flakers143613272flakers
flakey164410512flakey
flames114723692flames
flanes94522422flanes
flares94521702flares
flaxes165015352flaxes
flees85828752fl_ees
flexes164512952flexes
flies85630712fl_ies
flites95122442flites
floes85528142fl_oes
flubs105515442flu_bs
flue75329852flu_e_
flued95021252flu_ed
fluffs11347782fluffs
fluids10349422fluids
flukier14397852flukier
flukiest15248062flukiest
fluky154512292fluk_y
flume106021172flume_
flumed124915262flumed
flumps135112502flumps
flunked15398412flunked
flunker14389362flunker
flunkers15347532flunkers
flunkey17405792flunkey
flunkeys18263172flunkeys
flunkies1536392flunkies
flunks13469862flunks
fluors94311372fluors
flus75626542flu__s
flushes134114142flushes
flute86823752flute_
fluted104917162fluted
fluter95316862fluter
fluters103713672fluters
flutey125212522flutey
fluxed17509672fluxed
fluyts12367152fluyts
flytes123911562flytes
fumes105224702f_umes
fuses85628422f_uses
fuzes175120222f_uzes
fykes156312692f_ykes
glues65125682glu_es
glumes94516812glumes
glutes74517672glutes
jukes165319102_jukes
kluges11389562kluges
lakes95737652_lakes
likes96231902_likes
lubes74727992_lubes
luces75528432_luces
ludes65728852_ludes
lues45943552_lu_es
luges65928752_luges
lunes55337772_lunes
lures56138532_lures
lutes55836662_lutes
luxes124921502_luxes
nukes95418122_nukes
plumes104318132plumes
pluses83618072pluses
pukes114523022_pukes
slakes104021882slakes
slues54527172slu_es
ukes86122812__ukes

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 Filter178691825510.1261418182.5
2DLD Change Limit82551902.76629844.9
3Display Results90900.0303000.0
 (SQL Overall)178691902.92261153.7
 
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.