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

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

182 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
flambee14421001(None) 
flambe13489151flamb_e
flambeed16324381flambeed
flambes14419501flambes
clamber133311732clamber
flambeau1543322flambeau
flame105124442flam__e
flamed124618972flam_ed
flamen115215992flam_en
flamer114919122flam_er
flames114723692flam_es
flamier123112142flamier
flammed15377412flammed
flatbed13397982flatbed
lambed115614782_lambed
lamber104418492_lamber
lambie103213672_lambie
aflame1138723aflam__e
alamode1038153alamode
ambeer104511603__ambeer
amber94523213__amber
amble95924643__amble
baubee103215993_baubee
bawbee132714233_bawbee
blabbed11357813blabbed
blabber10418923blabber
blamable1436693blamable
blame95625493blam__e
blamed116017953blam_ed
blamer104417143blam_er
blames105121863blam_es
bramble133710033bramble
camber124418473_camber
chamber164011053chamber
clabber134210113clabber
clambake1843893clambake
clambered16146123clambered
clamberer15185263clamberer
clambers144211283clambers
clammed14369963clammed
clammer134211793clammer
clamped144012043clamped
clamper134012993clamper
climbed14336983climbed
climber13449133climber
clumber134011443clumber
crambe1239073cramb_e
crambes1339953crambes
fabber134814113f_abber
fable105824753f_a_ble
fame95639393f_am__e
famed115928343f_am_ed
fames105735923f_am_es
famine114318193f_amine
fiancee1238953fiancee
filagree1295143filagree
filaree10611193fila_ree
filmable15157133filmable
fimble133611753f_imble
flab96628353fla_b__
flabbier1534093flabbier
flabby1634573fla_bby
flabs105818643fla_b_s
flacked173711583flacked
flagged13459633flagged
flagger12469353flagger
flagmen13226913flagmen
flailed1137303flailed
flake125119973fla__ke
flaked144715653fla_ked
flaker134916173fla_ker
flakes134118873fla_kes
flakey164410513fla_key
flakier143910203flakier
flam96333293flam___
flambeaus1642883flambeaus
flambeaux2351683flambeaux
flambeing1743933flambeing
flamens124611063flamens
flamers124616363flamers
flamiest133111973flamiest
flamines13311633flamines
flaming134216443flaming
flammable1844173flammable
flams105125013flam__s
flamy135217473flam__y
flanes94522423fla_nes
flange103411973fla_nge
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flannel1035423flannel
flapped15328253flapped
flapper14359203flapper
flare84823633fla__re
flared105317603fla_red
flares94521703fla_res
flashed144112183flashed
flasher133914063flasher
flashes133916103flashes
flasket1439733flasket
flatbeds14364543flatbeds
flatfeet1446213flatfeet
flatlet10312253flatlet
flatmate1346393flatmate
flatted114012943flatted
flatten10429653flatten
flatter103815963flatter
flavine1338453flavine
flavone1335523flavone
flawed134712723fla_wed
flawier13378733flawier
flaxen16518573fla_xen
flaxes165015353fla_xes
flaxier17337983flaxier
flaxseed1942573flaxseed
flayed134414053fla_yed
flayer124713563fla_yer
flee76238793fl___ee
flubbed15306633flubbed
flubber14287713flubber
flume106021173flum__e
flumed124915263flum_ed
flumes115119733flum_es
flumped15377713flumped
flyable15307123flyable
flymen14387773flym_en
foamable1537043foamable
foamed126014403foam_ed
foamer114714313foam_er
foamier12339003foamier
formee113919943form_ee
framable1537573framable
frame105821803fram__e
framed125116523fram_ed
framer114817443fram_er
frames115119863fram_es
freebee1238043freebee
frisbee12298513frisbee
fumble133214263f_umble
gambe106219213_gamb_e
gambes116318313_gambes
gamble115417183_gamble
jambe165314753_jamb_e
jambed184811403_jambed
jambes175914053_jambes
label75019383_la_bel
lamb86832143_lamb__
lambda1146113_lambda
lambent113711303_lambent
lambers113817103_lambers
lambert113617113_lambert
lambier113611643_lambier
lambies113015113_lambies
lambs95921413_lamb_s
lamby125114843_lamb_y
lame66849293_lam__e
lamed85235293_lam_ed
lamer75233703_lam_er
lames75445543_lam_es
lamiae84817453_lamiae
lammed113915623_lammed
lamped114017543_lamped
laree56036293_la_ree
limbed114513183_limbed
limber104316793_limber
lumber103817773_lumber
mammee94417853_mammee
plumbed14317273plumbed
plumber13339983plumber
ramble104519973_ramble
ramee74633853_ram_ee
shamble14149263shamble
slabbed12409503slabbed
slabber113311393slabber
slammed123511103slammed
slammer113913033slammer
slumber113811003slumber
wamble134415753_wamble

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271827.57617691.0
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.81222873.9
 
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.