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

86 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
frockless184345(None) 
flockless1843161flockless
rockless14297291_rockless
feckless17225782f_eckless
fleckless1842892fleckless
forceless1435722forceless
forkless15267432f_orkless
freckles17126382freckle_s
frontless1235402frontless
frostless1235742frostless
knockless1442442knockless
reckless14257972_reckless
sockless14267792_sockless
trackless15246722trackless
backless162910633_backless
bractless1335543bractless
brickles162810283brickle_s
brockets16328123brock_ets
broodless1235033broodless
brooklets1543683brooklets
browless1346653bro_wless
checkless2044233checkless
clickless1743983clickless
cockles153414643_cockle_s
cookless14258633_cookless
crackles164111273crackle_s
crockets16339543crock_ets
cropless1237793cro_pless
crownless1443423crownless
faceless13269173f_aceless
fanciless1444603fanciless
fenceless1444163fenceless
ficklest17267903f_icklest
flockiest1835643flockiest
floorless1243793floorless
flourless1243533flourless
foamless13195843f_oamless
focusless1452263f_ocusless
fogless1138193f_o_gless
foodless12338383f_oodless
footless113710803f_ootless
fordless12289003f_ordless
formless13248083f_ormless
frameless1435533frameless
frankness1655223frankness
freckle16106643freckle__
freckled18104443freckle_d
freckliest1943383freckliest
fretless1138063fr_etless
frocked17439333frock_e_d
frocks154111213frock___s
froglets1235263fro_glets
frontlets1244233frontlets
fruitless1244163fruitless
graceless12226893graceless
grackles15309183grackle_s
groveless13235363groveless
hookless151238363_hookless
luckless14265893_luckless
neckless14236433_neckless
priceless1336893priceless
prickles162511103prickle_s
process11310403proc__ess
procuress1344093procuress
rankless12268243_rankless
riskless1235763_riskless
roadless937703_roadless
rockers133916553_rock_ers
rockets134615363_rock_ets
rockiest142912223_rockiest
rockiness15237833_rockiness
rodless8310073_ro_dless
roofless11316733_roofless
rootless83910443_rootless
ruckles133414603_ruckle_s
stackless1555933stackless
suckless14288823_suckless
tackless14419483_tackless
traceless11228643traceless
trickles143013763trickle_s
trochleas1444713trochleas
truceless11235393truceless
trucklers15295583trucklers
truckles14319383truckle_s
wickless1736083_wickless
workless15276803_workless

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 Filter1786911486410.453394461.4
2DLD Change Limit148641867.36020195.8
3Display Results86860.0461869.6
 (SQL Overall)178691867.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.