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

125 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
flyboy1711391(None) 
flyboys18112941flyboys
flyby1676001flyb_y
flabby1634572flabby
flyblow1841902flyblow
flyboat1546002flyboat
flybys1792772flybys
flyway18134692flyway
playboy1743812playboy
alloy85519973al_loy
anybody1642573anybody
batboy1387533batboy
bellboy1445123bellboy
blabby1234813blabby
blebby1233743blebby
boy87753563___boy
bullyboy1842423bullyboy
busboy13307443busboy
callboy1465833callboy
carboy134914183carboy
cloy96623833cl__oy
clubby1534683clubby
copyboy1963513copyboy
cowboy1637063cowboy
elbow10117703el_bow
feebly1436653feebly
feyly14429513fey_ly
flab96628353flab__
flabs105818643flab_s
flacon1138633flacon
flaggy14415923flaggy
flagon1037983flagon
flakey164410513flakey
flaky155715583fl_aky
flamy135217473fl_amy
flappy1654483flappy
flashy15498173flashy
flatly123110213flatly
flavor1236663flavor
flavory1644743flavory
flawy145913383fl_awy
flaxy189012293fl_axy
flay106332803fl__ay
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
flexor1634503flexor
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
floaty124210943floaty
floc95922123fl__oc
flocky18468423flocky
floe76129773fl__oe
flog85523893fl__og
flood95215603fl_ood
flooey123910173flooey
floor84215233fl_oor
floosy12368153floosy
floozy21356613floozy
flop96925453fl__op
floppy1654873floppy
flossy12517703flossy
floury12449573floury
flow105924923fl__ow
flub95721883flub__
flubs105515443flub_s
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flunky16408093flunky
fluor84512773fl_uor
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyable15307123flyable
flyaway1943163flyaway
flybelt1594453flybelt
flyblew1841403flyblew
flyblown1951563flyblown
flyblows1942013flyblows
flyboats1643863flyboats
flyer114916253fly_er
flyers125712803flyers
flying134612153flying
flyman14326423flyman
flymen14387773flymen
flyoff1444023flyoff
flysch1732893flysch
flyte115713943fly_te
flyted13378773flyted
flytes123911563flytes
flyways19133853flyways
fogbow1544783fogbow
footboy1544913footboy
forby135317673forb_y
foy96044263f___oy
fubsy13589273f_ubsy
fylfot1545043fylfot
fynbos1433283fynbos
glibly1236293glibly
globby1434683globby
glycol1254933glycol
labor75117313_labor
lobby125113923_lobby
lobo67229863_lobo_
lobos75921843_lobos
looby108115623_looby
lowboy1435903lowboy
playboys1843653playboys
plowboy1743183plowboy
ploy96123603pl__oy
poboy121612223_poboy
potboy1397813potboy
skybox2242293skybox
slobby1334803slobby
slyly11489533sly_ly
sybo9714743_sybo_
tallboy1265143tallboy
tomboy1358213tomboy

Search took 6 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.406440125.6
2DLD Change Limit1127161255.28021347.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911255.73231174.3
 
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.