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

191 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
flybys179277(None) 
flyboys18112941flyboys
flyby1676001flyby_
flabs105818642flab_s
flays116321052fl_ays
fleys117015602fl_eys
flubs105515442flub_s
flyboy17113912flyboy
flyers125712802flyers
flytes123911562flytes
flyways19133852flyways
abys97221883__abys
albas75925393al_bas
albs68628573al_b_s
alibis8311073alibis
allays94313743allays
alleys95113303alleys
alloys94014563alloys
always12409133always
blabs95619633blab_s
blebs96416153bleb_s
blobs95620033blob_s
blowbys17353813blowbys
blubs95818153blub_s
blueys11419523blueys
blypes13357543blypes
bys85229463___bys
clays105521333cl_ays
cloys104916943cl_oys
clubs95415103club_s
colbys13407153colbys
fabs98635863f_ab_s
fays108535363f__ays
feebs106112683feeb_s
feyly14429513feyly_
fibs96329503f_ib_s
flab96628353flab__
flabby1634573flabby
flacks154114533flacks
flags95321283fl_ags
flails94313003flails
flairs95711913flairs
flakes134118873flakes
flaky155715583flaky_
flambes14419503flambes
flames114723693flames
flams105125013fl_ams
flamy135217473flamy_
flanes94522423flanes
flanks133913403flanks
flans85327973fl_ans
flaps105621383fl_aps
flares94521703flares
flasks13488673flasks
flats86429743fl_ats
flatus94310783flatus
flaws115920343fl_aws
flawy145913383flawy_
flaxes165015353flaxes
flaxy189012293flaxy_
flay106332803fl_ay_
flayers133912033flayers
fleams115011943fleams
fleas86423663fl_eas
flecks154310803flecks
fleers96015793fleers
flees85828753fl_ees
fleets96915063fleets
flews115316443fl_ews
flexes164512953flexes
fley106626853fl_ey_
flicks154512993flicks
flics105418363fl_ics
fliers94417193fliers
flies85630713fl_ies
flimsy14345563flimsy
flings106715283flings
flints95617453flints
flips105117743fl_ips
flirs85518933fl_irs
flirts95411483flirts
flites95122443flites
flits85625223fl_its
floats96816253floats
flocks154713533flocks
flocs105519233fl_ocs
floes85528143fl_oes
flogs95919963fl_ogs
flongs105010493flongs
floods104511653floods
floors94112353floors
floosy12368153floosy
flops105920143fl_ops
floras94715693floras
floss85118263fl_oss
flossy12517703flossy
flotas94013003flotas
flours94414053flours
flouts94315273flouts
flows115822363fl_ows
flub95721883flub__
flues84626923fl_ues
fluffs11347783fluffs
fluids10349423fluids
flukes135114193flukes
fluky154512293fluky_
flumes115119733flumes
flumps135112503flumps
flunks13469863flunks
fluors94311373fluors
flus75626543fl__us
flutes95421783flutes
fluty114415643fluty_
fluxes165212933fluxes
fluyt114614203fl_uyt
fluyts12367153fluyts
fly97124953fl__y_
flyable15307123flyable
flyaways2042813flyaways
flybelt1594453flybelt
flybelts1682753flybelts
flyblew1841403flyblew
flyblow1841903flyblow
flyblows1942013flyblows
flyboat1546003flyboat
flyboats1643863flyboats
flyer114916253fly_er
flying134612153flying
flyings14496063flyings
flyless1335003flyless
flyman14326423flyman
flymen14387773flymen
flyoff1444023flyoff
flyoffs1542253flyoffs
flypast1583753flypast
flysch1732893flysch
flyte115713943fly_te
flyted13378773flyted
flyway18134693flyway
fobs96034273f_ob_s
fogeys13509263fogeys
foleys123810463foleys
forays124813003forays
forbs105720803forb_s
forby135317673forby_
forbye14427883forbye
foyers125413133foyers
foys105628293f__oys
frays116920103f_rays
fryers125710973fryers
fubs96328793f_ub_s
fubsy13589273f_ubsy
fyces139813643f_yces
fykes156312693f_ykes
fynbos1433283fynbos
glebes95512243glebes
gleys96514853gl_eys
globes94314543globes
globs85616403glob_s
glycyl1542793glycyl
glycyls1642063glycyls
glyphs1534303glyphs
gybes115012723_gybes
labs67145123_lab_s
lays76043253_l_ays
leys76430183_l_eys
libs66732763_lib_s
lobes75331003_lobes
lobos75921843_lobos
lobs66441083_lob_s
lubes74727993_lubes
lyes75530833_ly_es
lyres85019963_lyres
lyses84518253_lyses
lysis84511463_lysis
maybes1339243maybes
platys11459853platys
playboys1843653playboys
plays106320773pl_ays
plebes104313623plebes
plebs95814583pleb_s
ploys105816593pl_oys
plyers114912983plyers
slabs75322643slab_s
slays85723683sl_ays
slobs74419873slob_s
slubs74719533slub_s
slyly11489533slyly_
slypes114410483slypes
yays105728913__yays
zlotys18374173zlotys

Search took 7 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127161916.25018034.6
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.46927622.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.