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

224 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
flockier174534(None) 
blockier1666131blockier
blocker15419922block_er
clocker153910872clock_er
cockier154013622_cockier
flakier143910202fl_akier
flicker163610622flick_er
floatier1136982floatier
flocked174510252flock_ed
flockiest1835642flockiest
flocking183410872flocking
floppier1554632floppier
flossier11326972flossier
flukier14397852fl_ukier
folkier14359042f_olkier
forkier144311582f_orkier
locker124019422_lock_er
luckier133811532_luckier
pluckier16295072pluckier
pockier153911602_pockier
rockier134911882_rockier
shlockier1842572shlockier
stockier14217252stockier
blacker154513513black_er
blockader1843113blockader
blocked16449983block_ed
blockers16398793block_ers
blockiest1736363blockiest
blocking174510573blocking
blockish19115793blockish
bloodier1136823bloodier
bloomier1275783bloomier
blotchier1643213blotchier
blottier10336413blottier
blousier1055663blousier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
boskier13309173_boskier
brickier16307163brickier
chokier1638043cho_kier
clacker153813773clack_er
clankier14327083clankier
clicker154111883click_er
clocked164112833clock_ed
clockers16369813clock_ers
clocking174312413clocking
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clunkier14345793clunkier
cocker144320393_cock_er
colickier1743513colickier
corkier133114303_corkier
croakier14436263croakier
dickier143512453_dickier
docker134417653_dock_er
dorkier122810023_dorkier
duckier143911793_duckier
fancier123412063fanc_ier
fickler16348423f_ickler
finickier1842623finickier
flabbier1534093flabbier
flacked173711583flack_ed
flackery20295243flack_ery
flacking184311793flacking
flaggier13105203flaggier
flaker134916173fl_ak_er
flamier123112143fl_amier
flanker143911293flank_er
flappier1544293flappier
flashier1437103flashier
flawier13378733fl_awier
flaxier17337983fl_axier
flecked17358073fleck_ed
flecking18408233flecking
fledgier1333683fledgier
fleecier1334763fleecier
fleshier1435603fleshier
flichter1664963flichter
flicked174610673flick_ed
flickers17338883flick_ers
flickery20365103flick_ery
flicking184110043flicking
flier86023403fl___ier
flimsier1344133flimsier
flintier1136393flintier
flirtier1144883flirtier
floater104413353flo_ater
flocced15365483floc_ced
flocci1335023flocci__
floccing16306033floccing
flock144717423flock___
flockings19314343flockings
flockless1843163flockless
flocks154713533flock__s
flocky18468423flock__y
flogger12449463flo_gger
flooder11258463flo_oder
flooie93712153flo_oie_
floorer10248073flo_orer
floosie10378933floosie_
floosies113210233floosies
floozie19295453floozie_
floozies20326953floozies
flopover1642863flopover
flopper14328473flo_pper
floppies1546813floppies
flosser10339693flo_sser
flossie10337443flossie_
flossies112810123flossies
flouncier1442483flouncier
flounder1235103flounder
flouter104311343flo_uter
flower124815503flo__wer
flowerer1435453flowerer
flowerier1544273flowerier
fluffier13264333fluffier
flunker14389363flunk_er
flunkie1434513flunkie_
flunkies1536393flunkies
flutier103011553fl_utier
flytier13356503fl_ytier
foamier12339003f_oamier
focuser12155783f_ocuser
foggier12349913f_oggier
folkie13369613f_olkie_
folkies143612253f_olkies
folksier1533533folksier
footier104115113f_ootier
forker134717903f_ork_er
foxier163910033f_o_xier
fozier183710663f_o_zier
freakier15246483freakier
frecklier1842993frecklier
friskier1535193friskier
frocked17439333frock_ed
frocking18309573frocking
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowzier2343313frowzier
fucker153414423f_uck_er
funkier14349983f_unkier
glacier103911293glac_ier
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
hocker155118563_hock_er
hokier134214033_ho_kier
hookier143811673_hookier
ickier12439923__ickier
jokier17618753_jo_kier
kickier12349053_kickier
knocker12296393knock_er
kookier10398283_kookier
lacier84020093_lac_ier
lacker125325623_lack_er
lakier104716273_l_akier
lankier113711633_lankier
larkier113711523_larkier
leakier114010993_leakier
licker125222043_lick_er
loamier9349163_loamier
locater93113603_locater
locked134921663_lock_ed
lockers133516923_lock_ers
locket123922473_lock_et
locking143718153_locking
lockset13311163_lockset
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
looker104816953_look_er
loonier73312683_loonier
loopier93711193_loopier
loppier11369723_loppier
lousier72411623_lousier
lowlier10338903_lowlier
luckie123611413_luckie_
luckies133313683_luckies
mocker143315443_mock_er
muckier153411473_muckier
oakier104011393__oakier
ocker113915753__ock_er
peckier153910523_peckier
pickier153912973_pickier
plottier10327263plottier
plucker15368243pluck_er
plunkier14305323plunkier
pokier124914633_po_kier
porkier133712343_porkier
prickier16368143prickier
quackier23215373quackier
rocker124319573_rock_er
rookier114012383_rookier
schlockier2141703schlockier
shocker163411423shock_er
slacker133915293slack_er
sleekier1245573sleekier
slicker133314533slick_er
slinkier12206933slinkier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slouchier1443603slouchier
smokier1356703smo_kier
spookier14175493spookier
stickier14229763stickier
stocker133713083stock_er
suckier133613973_suckier
tackier133712523_tackier
trickier143010233trickier
unluckier1541933unluckier
wackier16369733_wackier
whackier2044673whackier
wonkier1437423_wonkier
yolkier14336123_yolkier
yuckier16358533_yuckier

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622247.05020732.2
3Display Results2242240.0762947.4
 (SQL Overall)1786912247.29624491.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.