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

143 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
flounce123541(None) 
flounced1433801flounced
flounces1335101flounces
flouncy1543671flouncy
frounce1236151frounce
bounce104014832_bounce
enounce937572enounce
florence1347062florence
flouncier1442482flouncier
flounder1235102flounder
frounced1434492frounced
frounces1336182frounces
jounce153310732_jounce
launce8469182_launce
lounge75211212_lounge
ounce77019932__ounce
pounce105214092_pounce
trounce936822trounce
aliunde835003aliunde
almuce10348213almu_ce
alone55732963alo_n_e
announce1044323announce
bedunce1235683bedunce
blonde94813293blo_nde
blouse84714723blou_se
blunge94311483bl_unge
bounced123610553_bounced
bouncer113811333_bouncer
bounces113813683_bounces
bouncy13409073_bouncy
clone75728163clo_n_e
denounce1145103denounce
douce85518423_dou_ce
dunce86319263__dunce
eloquence2053333eloquence
enounced1135883enounced
enounces1037603enounces
faience1237513faience
faunae95210373f_aunae
fence105319913f__ence
fiance11310743f_iance
finance1238573finance
flange103411973fl_ange
flaunt9712913flaun_t
flaunted1234603flaunted
flaunter1135013flaunter
flaunts1056133flaunts
flaunty1354413flaunty
fleece11369903fl_eece
flench144010813fl_ench
flense938903fl_ense
flinch144010103fl_inch
floc95922123flo__c_
flocced15365483flo_cced
flocci1335023flo_cci
flock144717423flo__ck
flocs105519233flo__cs
floe76129773flo___e
flong95815683flo_n_g
flongs105010493flo_ngs
flooie93712153flo_oie
floosie10378933floosie
floozie19295463floozie
florae94713883flo_rae
florences1446893florences
flossie10337443flossie
flotage1136683flotage
flounciest1542563flounciest
flouncing1533903flouncing
flounders1374613flounders
flour84916453flou__r
floured11289873floured
flours94414053flou_rs
floury12449573flou_ry
flout86226203flou__t
flouted113210813flouted
flouter104311343flouter
flouts94315273flou_ts
flowage1435723flowage
flown116213993flown__
flue75329853fl_u__e
fluency1545353fluency
fluke125016893fl_u_ke
flume106021173fl_u_me
flung95114583fl_un_g
flunk125014383fl_un_k
flunked15398413fl_unked
flunker14389363fl_unker
flunkey17405793fl_unkey
flunkie1434513fl_unkie
flunks13469863fl_unks
flunky16408093fl_unky
flute86823753fl_u_te
force105324273f_o_rce
found94917843f_oun_d
founded124011423f_ounded
founder114312573f_ounder
founds104814193f_ounds
fount84727033f_oun_t
founts94313383f_ounts
furuncle1342153furuncle
glance94312313gl_ance
glunch1255353gl_unch
jaunce15367433_jaunce
jounced17337613_jounced
jounces16369853_jounces
jouncy18336203_jouncy
lance75126723_l_ance
launces9329003_launces
launch11368063_launch
lone45849133_lo_n_e
longe66626463_lo_nge
loonie64216453_loonie
louche115212663_louche
louie55023513_lou_ie
lounged9468243_lounged
lounger84610213_lounger
lounges84811353_lounges
loungy10476833_loungy
loupe75319513_lou_pe
louse56131013_lou_se
louvre9425683_louvre
luce65132573_l_u_ce
lunch104917243_l_unch
lune47140493_l_un_e
lunge65323803_l_unge
nonce75719823_no_nce
once65423083__o_nce
ounces83617773__ounces
plunge93811053pl_unge
ponce95222513_po_nce
pounced123510623_pounced
pouncer113511233_pouncer
pounces114113893_pounces
renounce1047403renounce
sconce104711723sco_nce
slouch11438523slou_ch
sluice849513sl_uice
source8410673_source
trounced1135033trounced
trouncer1035443trouncer
trounces1037063trounces
usaunce9103383usaunce

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.406440125.6
2DLD Change Limit1340271437.11018850.5
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.56223630.1
 
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.