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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
flyboys1811294(None) 
flyboy17113911flyboy_
flybys1792771flyb_ys
flyblows1942012flyblows
flyboat1546002flyboat
flyboats1643862flyboats
flyby1676002flyb_y_
flyways19133852flyways
playboys1843652playboys
alloys94014563al_loys
batboys1465833batboys
bellboys1544513bellboys
boys96737333___boys
bullyboys1942263bullyboys
busboys14325023busboys
callboys1585173callboys
carboys144711783carboys
cloys104916943cl__oys
copyboys2042663copyboys
cowboys1735253cowboys
elbows1196713el_bows
flabby1634573flabby_
flabs105818643flab__s
flacons1238053flacons
flagons1137973flagons
flavors1337293flavors
flays116321053fl__ays
flexors1734773flexors
fleys117015603fl__eys
flocs105519233fl__ocs
floes85528143fl__oes
flogs95919963fl__ogs
floods104511653fl_oods
floors94112353fl_oors
floosy12368153fl_oosy
flops105920143fl__ops
floss85118263fl__oss
flows115822363fl__ows
flubs105515443flub__s
fluors94311373fl_uors
flyaways2042813flyaways
flybelt1594453flybelt
flybelts1682753flybelts
flyblew1841403flyblew
flyblow1841903flyblow
flyblown1951563flyblown
flyers125712803fly_ers
flyings14496063flyings
flyless1335003flyless
flyoff1444023fly_off
flyoffs1542253flyoffs
flytes123911563fly_tes
flyway18134693flyway_
fogbows1643853fogbows
footboys1644333footboys
foys105628293f___oys
fylfots1642423fylfots
fynbos1433283fynbo_s
globous1036493globous
glycols1344133glycols
labors84016403_labors
lobos75921843_lobo_s
lowboys1534213lowboys
playboy1743813playboy_
plowboys1842363plowboys
ploys105816593pl__oys
poboys1397313_poboys
potboys1475273potboys
slyboots1343373slyboots
syboes1139343_syboes
tallboys1374613tallboys
tomboys1435703tomboys

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 Limit134027726.95319276.1
3Display Results72720.0164500.0
 (SQL Overall)178691727.12525079.4
 
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.