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

134 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
flub9572188(None) 
blub85324871blub
club85819471club
flab96628351flab
flu66530211flu_
flubs105515441flubs
flue75329851flue
flus75626541flus
flux145617741flux
fub86337391f_ub
slub65428031slub
alb57342652al_b
alum65227612alum
blab86629132blab
bleb85425222bleb
blob86027092blob
blubs95818152blubs
blue65328462blue
blur66020532blur
blurb95214902blurb
bub76343972_bub
bulb85626692bulb
chub115516412chub
clubs95415102clubs
clue65324532clue
cub76940942_cub
daub77423442daub
drub75920132drub
dub66642202_dub
fab87453132f_ab
faun76226622faun
faux146519072faux
feeb96924542feeb
feu67843662feu_
feud86523022feud
feus75830752feus
fib86344262f_ib
filum105015432filum
flabs105818642flabs
flag87427082flag
flak116026172flak
flam96333292flam
flan76134182flan
flap96128702flap
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
flea75628492flea
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
floc95922122floc
floe76129772floe
flog85523892flog
flop96925452flop
flour84916452flour
flout86226202flout
flow105924922flow
flued95021252flued
flues84626922flues
fluff103913612fluff
fluid94013962fluid
fluke125016892fluke
fluky154512292fluky
flume106021172flume
flump124614722flump
flung95114582flung
flunk125014382flunk
fluor84512772fluor
flush115116072flush
flute86823752flute
fluty114415642fluty
fluyt114614202fluyt
fly97124952fl_y
flyby1676002flyby
fob86748332f_ob
forb97131332forb
fou66743782fou_
foul77027582foul
four76226862four
frug86517102frug
fubs96328792f_ubs
fud76335152f_ud
fug76234512f_ug
full75229152full
fun66841142f_un
fur66637322f_ur
glib79421432glib
glob76623392glob
glue55628492glue
glug66118012glug
glum75825102glum
glut56331292glut
grub77220082grub
hub86437482_hub
lab58864782_lab
lib57750262_lib
lob57154462_lob
lube64731562_lube
lug46138062_lug
lum55542932_lum
luv67125772_luv
lux106528772_lux
nub56439142_nub
pleb86123812pleb
plug74915992plug
plum85122102plum
plumb114514072plumb
plus66324832plus
pub76037692_pub
rub56342822_rub
shlub105411742shlub
slab67133762slab
slob66029422slob
slubs74719532slubs
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slurb74116322slurb
slut45040592slut
snub65320762snub
stub66221842stub
sub55445552_sub
tub55640032_tub
ulu36028702ulu_
ulus45622562ulus

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 Filter178691298720.0931921408.6
2DLD Change Limit298721340.96630923.4
3Display Results1341340.0334060.6
 (SQL Overall)1786911341.092163636.4
 
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.